查询表A中所有信息的SQL语句是（ ）。
A: SELECT ALL ON A;
B: SELECT * FROM A;
C: SELECT ALL WHERE A;
D: SELECT * WHERE A;
A: SELECT ALL ON A;
B: SELECT * FROM A;
C: SELECT ALL WHERE A;
D: SELECT * WHERE A;
举一反三
- 查询曾经考过100分的学生的学号，可以使用的SQL语句是：（ ） A: SELECT ALL Sno FROM SC WHERE Grade = 100; B: SELECT DISTINCT Sno FROM SC WHERE Grade = 100; C: SELECT ALL Sno FROM Student WHERE SGrade = 100; D: SELECT DISTINCT Sno FROM Student WHERE SGrade = 100;
- 查询所有非计算机系学生的信息，不正确的SQL语句是：（ ） A: SELECT * FROM Student WHERE Sdept != 'CS'; B: SELECT * FROM Student WHERE NOT Sdept = 'CS'; C: SELECT * FROM Student WHERE Sdept IN ('MA', 'IS'); D: SELECT * FROM Student WHERE NOT Sdept IN ('CS');
- 在学生表STUD中查询所有姓张的学生的信息，使用的SQL语句是______。 A: SELECT*FROM STUD WHERE 姓名 LIKE"张%” B: SELECT*FROM STUD WHERE 姓名 IN("张%") C: SELECT*FROM STUD WHERE 姓名 LIKE"张$" D: SELECT*FROM STUD WHERE 姓名 IN"张$)"
- 通过 SQL，您如何从 "Persons" 表中选取 "FirstName" 列的值等于"Peter" 的所有记录？ A: SELECT [all] FROM Persons WHERE FirstName='Peter' B: SELECT * FROM Persons WHERE FirstName LIKE 'Peter' C: SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' D: SELECT * FROM Persons WHERE FirstName='Peter'
- 下列____是Select数据库查询语句中不可缺少的。 A: Select、From B: Select、Where C: From、Order By D: Select、All