SQL case when else 语句：选出年份等于1970的，选出的结果用科目和获奖者排序，同时把经济和化学2科放到最后：SELECT * FROM nobel_win WHERE year=1...

 

 

SELECT * FROM nobel_win WHERE year=1970 ORDER BY  CASE WHEN subject IN ('Economics','Chemistry') THEN 1 ELSE 0 END ASC, subject, winner;

转载于:https://www.cnblogs.com/books2read/p/11170535.html