Java面试总结mysql

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)

Java面试总结mysql

标签：images   java   microsoft   es2017   ack   .com   fan   play   family