- 用一条SQL 语句 查询出每门课都大于80 分的学生姓名名称是dateTable
1. select distinct name from student where name not in (select distinct name from student where grade<=80)
2. select name from student group by name having min(grade)>80
2怎样将上面这张表转化为下面这张表
select year,
(select amount from dateTable m where month=1 and m.year=dateTable.year) as m1,
(select amount from dateTable m where month=2 and m.year=dateTable.year) as m2,
(select amount from dateTable m where month=3 and m.year=dateTable.year) as m3,
(select amount from dateTable m where month=4 and m.year=dateTable.year) as m4
from dateTable group by year