满意答案
huangjiaxinxl
推荐于 2018.03.04
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:
其他几道没有把握....就不放出来了
44分享举报