1.根据部门号从高到低，工资从低到高列出每个员工的信息。
SELECT * FROM User ORDER BY deptid DESC ,salary
2.用一条sql语句查询出每门课都大于80的学生姓名
select distinct name from Student where name not in (select distinct name from student where fenshu<=80)
原文：http://www.cnblogs.com/sbj-dawn/p/7800247.html