SQL按照特定顺序排序:
ALTER TABLE student
ALTER COLUMN AGE nvarchar(50) COLLATE Chinese_PRC_CI_AS
select * from student order by BELONG_AGE s
按照特定顺序排序:
select * from student order by
case BELONG_AGE when '第一' then 1
When '第二' then 2
when '第三' then 3
end asc