order by对结果进行排序

SELECT field1, field2,field3 ... fieldn

    FROM tablename

        ORDER BY fieldm [ASC|DESC]

ASC 升序排序

DESC 降序排序

实例：

SELECT stuid,name,chinese 
    FROM score
        ORDER BY chinese ASC;