使用SQL语句查询学生信息表tbl_student中的所有数据,并按学生学号stu_id升序排列,正确的语句是()
A: SELECT*FROMtbl_studentORDERBYstu_idASC;
B: SELECT*FROMtbl_studentORDERBYstu_idDESC;
C: SELECT*FROMtbl_studentstu_idORDERBYASC;
D: SELECT*FROMtbl_studentstu_idORDERBYDESC;
A: SELECT*FROMtbl_studentORDERBYstu_idASC;
B: SELECT*FROMtbl_studentORDERBYstu_idDESC;
C: SELECT*FROMtbl_studentstu_idORDERBYASC;
D: SELECT*FROMtbl_studentstu_idORDERBYDESC;
举一反三
- 从学生表student查询学生的所有信息，正确的语句是______。 A: SELECT#FROMstudent B: SELECT*FROMstudent; C: SELECT?FROMstudent; D: SELECT_FROMstudent;
- 查询学生表的所有记录的所有字段，SQL语句是 A: select 学生 from *； B: select * from 学生; C: select*from学生； D: select 所有记录所有字段 from 学生;
- 下面选项中,查询stu表中id值不在2和5之间的学生的SQL语句是( )。 A: select * from stu where id != 2,3,4,5; B: select * from stu where id not betwen 5 and 2; C: select * from stu where id not betwen 2 and 5; D: select * from stu where id not in 2,3,4,5;
- 下面选项中,查询student表中id值不在2和5之间的学生,其中正确的SQL语句是() A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;
- 下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是 A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;