SELECT field1, field2,field3 ... fieldn
FROM tablename
ORDER BY fieldm [ASC|DESC]
ASC 升序排序
DESC 降序排序
实例:
SELECT stuid,name,chinese FROM score ORDER BY chinese ASC;
技术 · 思考 · 实践 · 成长
SELECT field1, field2,field3 ... fieldn
FROM tablename
ORDER BY fieldm [ASC|DESC]
ASC 升序排序
DESC 降序排序
实例:
SELECT stuid,name,chinese FROM score ORDER BY chinese ASC;
泰山崩于前而色不变,麋鹿兴于左而目不瞬,然后可以制利害,可以待敌。--心术