mysq多个字段排序,查询结果去重
# 以Cno升序、Degree降序查询Score表的所有记录
-----多个字段的时候,用逗号隔开
SELECT *FROM scores ORDER BY cno ASC,degree DESC;
# 查询教师所有的单位即不重复的Depart列
------对字段去重
SELECT DISTINCT depart FROM teachers;
# 以Cno升序、Degree降序查询Score表的所有记录
-----多个字段的时候,用逗号隔开
SELECT *FROM scores ORDER BY cno ASC,degree DESC;
# 查询教师所有的单位即不重复的Depart列
------对字段去重
SELECT DISTINCT depart FROM teachers;