温故余学

摘要： 1 ''按多个字段排序 2 Select * From Job order by job desc,id asc 3 4 ''按首字符(非数字)排序 5 Select * From Job order by case when isnumeric(left(jobno,1))=0 6 Then left(jobno,1) end 7 8 ''按首字符分组 9 Select ... 阅读全文