1.对指定单列进行排序
查询分数表中编号为1的所有分数信息,并用下列两种方式排序
1.1升序排序
SELECT * FROM scores
WHERE gno=1
ORDER BY score ASC
1.2降序排序
SELECT * FROM scores
WHERE gno=1
ORDER BY score DESC
2.多列排序(注意排列的依据:ORDER BY)
2.1先编号升序排序,后分数降序排序
SELECT * FROM scores
ORDER BY gno ASC ,score DESC