A.SELECT * FROM stud ORDER BY birthday DESC LIMIT 8;
B.SELECT * FROM stud ORDER BY birthday ASC LIMIT 8;
C.SELECT * FROM stud ORDER BY birthday ASC LIMIT 7;
D.SELECT * FROM stud ORDER BY birthday DESC LIMIT 7;
A.100
B.6
C.2
D.1
A.select学号,姓名,课程号,成绩from学生,选课where籍贯="湖南"
B.select学号,姓名,课程号,成绩from学生,选课where学生.学号=选课.学号and籍贯="湖南"
C.select学号,姓名,课程号,成绩from学生,选课;where学生.学号=选课.学号or籍贯="湖南"
D.select学生.学号,姓名,课程号,成绩from学生,选课;where学生.学号=选课.学号and籍贯="湖南"
A.SELECTSN,AGE,SEXFROMSWHEREAGE>(SELECTAGEFROMS;WHERESN='王华')
B.SELECTSN,AGE,SEXFROMSWHERESN='王华'
C.SELECTSN,ACE,SEXFROMSWHEREAGE>(SELECTACEWHERESN='王华')
D.SELECTSN,ACE,SEXFROMSWHEREACE>王华AGE
A.SELECT单位,COUNT(借阅.借书证号)FROM借阅,读者WHERE借阅.借书证号=读者.借书证号ORDERBY单位
B.SELECT单位,COUNT(借阅.借书证号)FROM借阅,读者WHERE借阅.借书证号=读者.借书证号GROUPBY单位
C.SELECT单位,SUM(借阅.借书证号)FROM借阅,读者WHERE借阅.借书证号=读者.借书证号HAVING单位
D.SELECT单位,SUM(借阅.借书证号)FROM借阅,读者WHERE借阅.借书证号=读者.借书证号GROUPBY单位
A.SELECT仓库号,COUNT(*),SUM(工资)FROM职工WHERECOUNT(*)>=4
B.SELECT仓库号,COUNT(*),SUM(工资)FROM职工;GOURPBY仓库号SETCOUNT(*)>=4
C.SELECT仓库号,COUNT(*),SUM(工资)FROM职工GOURPBY仓库号HAVINGCOUNT(*)>=4
D.SELECT仓库号,COUNT(*),SUM(工资)FROM职工GOURPBY仓库号WHERECOUNT(*)>=4
A.DECLARE@MyvarINT
B.SELECT*FROM[AAA]
C.CREATE DATABASE AAA
D.DELETE* FROM AAA
A.SELECT学号,课程号FROM成绩WHERE分数ISNOTNULL
B.SELECT学号,课程号FROM成绩WHERE分数ISNULL
C.SELECT学号,课程号FROM成绩WHERE分数=NULL
D.SELECT学号,课程号FROM成绩WHERE分数NULL
A.DENY SELECT FROM 帐户 ON Jean
B.DENY UPDATE ON 帐户 TO Jean
C.DENY INSERT INTO 帐户 ON Jean
D.DENY UPDATE FROM 帐户 ON Jean