Select学号,姓名From Information Where 班级名称=’软件01’表示()。
A.查询Information表中“软件01”班学生的学号、姓名
B.查询Information表中“软件02”班学生的所有信息
C.查询Information表中学生的学号、姓名
D.查询Information表中计算机系学生的记录
A.查询Information表中“软件01”班学生的学号、姓名
B.查询Information表中“软件02”班学生的所有信息
C.查询Information表中学生的学号、姓名
D.查询Information表中计算机系学生的记录
A.SELECT
B.UPDATE
C.WHERE
D.FROM
A. SELECT Sno, Sname FROM sC WHERE Grade>75
B. SELECT Sno, Sname FROM Student WHERE Grade>75
C. SELECT Sno, Sname FROM Student WHERE Sno lN(SELECT Sno FROM SC WHERE Grade>75 )
D. SELECT Sno, Sname FROM Student WHERE Sno lN(SELECT Sno FROM SC HAVING Grade>75 )
在student表上创建 view_stu视图。包含学生的学号,姓名,年龄,所在系
create () view_stu as select sno,sname,sage,sdept from student
A.100
B.6
C.2
D.1
A.The collective number makes it easier to select quotation documents for the price comparison
B.The collective number makes it easier to select documents for generating info records from quotations
C.The collective number makes it easier to select documents for generating source list entries from quotations
D.The collective number makes it easier to select documents for message output of requests for quotations
A.SELECT学号,姓名FROMSWHERENOTEXISTS(SELECT﹡FROMSCWHERESC.学号=S.学号AND成绩<85)
B.SELECT学号,姓名FROMSWHERENOTEXISTS(SELECT﹡FROMSCWHERESC.学号=S.学号AND成绩>=85)
C.SELECTS.学号,姓名FROMS,SCWHERES.学号=SC.学号AND成绩>=85
D.SELECT学号,姓名FROMS,SCWHERES.学号=SC.学号ANDALL成绩>=85
A.SELECT学号,课程号FROM成绩WHERE分数ISNOTNULL
B.SELECT学号,课程号FROM成绩WHERE分数ISNULL
C.SELECT学号,课程号FROM成绩WHERE分数=NULL
D.SELECT学号,课程号FROM成绩WHERE分数NULL
A.SELECT姓名FROM学生WHERE出生日期 >=#2006/1/1#
B.SELECT姓名FROM学生WHERE出生日期 >=2006/1/1
C.SELECT姓名FROM学生WHERE出生日期 >="2006/1/1"
D.SELECT姓名FROM学生WHERE出生日期 >2006/1/1
A.SELECT姓名,COUNT(﹡)AS外币种类FROM持有数GROUPBY姓名HAVINGCOUNT(﹡)>=4ORDERBY外币种类,姓名DESC
B.SELECT姓名,COUNT(﹡)AS外币种类FROM持有数GROUPBY姓名HAVINGCOUNT(﹡)>=4ORDERBYCOUNT(﹡),姓名DESC
C.SELECT姓名,COUNT(﹡)AS外币种类FROM持有数GROUPBY姓名HAVINGCOUNT(﹡)>=4ORODERBY外币种类AND姓名DESC
D.SELECT姓名,COUNT(﹡)AS外币种类FROM持有数GROUPBY姓名HAVINGCOUNT(﹡)>=4ORDERBY外币种类+姓名DESC
A.SELECT*FROM员工WHERE姓名LIKE"曾*"
B.SELECT*FROM员工WHERE姓名LIKE"曾?"
C.SELECT*FROM员工WHERE姓名LIKE"*曾*"
D.SELECT*FROM员工WHERE姓名LIKE"?曾?"