引用集合数据类型中的元素选择sub数组中第一个元素进行查询,正确的是（ ）
A: select name,subordinates[0] from emplyees;
B: select name,subordinates[1] from emplyees;
C: select name,subordinates from emplyees;
D: 以上都不正确
A: select name,subordinates[0] from emplyees;
B: select name,subordinates[1] from emplyees;
C: select name,subordinates from emplyees;
D: 以上都不正确
举一反三
- 下面正确表示查询goods表中type和name的SQL语句是。 A: select * from goods; B: select type name from goods; C: select type,name from goods; D: select name type from goods;
- 若想查询student表中name为空值的记录，则正确的SQL语句是（ ）。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;
- 若想查询student表中name为空值的记录，则正确的SQL语句是（1.0分） A: select * from student where name = null; B: select * from student where name link null; C: select * from student where name = 'null'; D: select * from student where name is null;
- 关于查询中列的别名, 以下（）语句是不正确的（选一项） A: Select name as '姓名' from table B: Select name as姓名 from table where id =1 C: Sleect name = 姓名 from table D: Select names姓名 from table
- 下面查询语句中哪条查询语句会查询出所有包含"李"的数据？ A: select * from student where name limit‘%李%’ B: select * from student where name =‘%李%’ C: select * from student where name like‘%李%’ D: select * from student where name in‘%李%’