【单选题】查询student表中不同性别学生人数
A.
SELECT COUNT(*),gender FROM student ;
B.
SELECT COUNT(gender) FROM student ;
C.
SELECT COUNT(*),gender FROM student GROUP BY gender;
D.
SELECT COUNT(*),gender FROM student ORDER BY gender;
【简答题】在学生成绩表Student_course中查询所有成绩的前5名。
【单选题】使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:______。
A.
SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”
B.
SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”
C.
SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”
D.
SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”
【简答题】使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:A)SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”B)SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”C)SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”D)SELECT*FROM STUDENT WHERE STR(姓名,2...
【单选题】在Student表中查询1998年出生女同学的学号、姓名。Student表:【图片】
A.
SELECT studentNo, studentName FROM Student WHERE year(birthday)=1998 AND sex='女'
B.
SELECT studentNo, studentName FROM Student WHERE year(birthday)=1998
C.
SELECT studentNo, studentName FROM Student WHERE birthday=1998 AND sex='女'
D.
SELECT studentNo, studentName FROM Student WHERE birthday=1998
【简答题】表student与class联合查询,要求查询所有学生的学号,姓名,成绩,班级名称写出相应的SQL语句,表student与class联合查询,要求查询所有学生的学号,姓名,成绩,班级名称。
【简答题】按班级升序排序,成绩降序排序,查询student表的所有记录写出相应的SQL语句:按班级升序排序,成绩降序排序,查询student表的所有记录。