查询全体学生的姓名及其出生年份 （数据库）

1: select name , age from student;

2: select major_num from student where major = '计算机专业';

3: select * from student where age >19;

4: select name , ID from stduent where major = '...';

5: select name , age from student where sex = '男' or age >19

6: select name , ID , sex from student where name like '王%'

7: select name , ID , sex from student where name NOT like '王%'

8: select name , ID , sex from student where name NOT like '_佳%'

9: select name , age ,major where age like [18-25]

10: select name , age ,major where age NOT like [18-25]

11: select * from student where name = (select major from student
where name = '王涛')

12: select ID,name from student where major_id = 001

13: select ID,name from student where major_id <> 001

14: select * from student where zhuanyechengji > 80

15: select ID,score from student where major_id = 001
Order by score DESC

16: select * from student order by age DESC ,major

17:

18: select count(*) from student

19: select count(*) from student where EXISTS (select scroe from

student)

20:

21:

22:

其他几道没有把握....就不放出来了