course表设计如下，查询所有的课程信息，并按学分的由高到低排序显示。正确SQL语句是（）
A. select * from course order by grade ;
B. select * from course order by grade desc;
C. select * , grade from Sourse order by grade desc;
D. select * , grade from course order by grade asc ;
查看答案
course表设计如下：查询所有的课程信息，并按学分的由低到高排序显示。正确SQL语句是（）
A. select * from course order by grade;
B. select * , grade from Sourse order by grade asc;
C. select * , grade from course order by grade;
D. select * , grade from course order by grade desc;
course表设计如下，查询所有学分在3-5分之间的课程名称的正确SQL语句是（）
A. select cname from course where grade on （3,5）;
B. select cname from course where grade >= 3 and grade <= 5;
C. select cno from course where grade >= 3 and grade <= 5;
D. select cname from course where 3<=grade<=5;
student表设计如下，查询所有年龄在18-25岁之间的学生姓名和性别的正确SQL语句是（）
A. select sname ,sex from student where （year（getdate（））-YEAR（birth））>=18 and （year（getdate（））-YEAR（birth））<=25;
B. select sname ,sex from student where birth between 18 and 25;
C. select sname ,sex from student where YEAR<=1997 and YEAR>=1990;
D. select sname ,sex from student where birth in （1997,1990）;
要查询book表中所有书名中包含“计算机”的书籍情况，可用（ ）语句。
A. SELECT * FROM book WHERE book_name LIKE ‘%计算机%’
B. SELECT * FROM book WHERE book_name LIKE ‘计算机%’
C. SELECT * FROM book WHERE book_name = ‘计算机*’
D. SELECT * FROM book WHERE book_name = ‘计算机%’
微信支付 
支付宝支付