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‘%李%’
内容
- 0
表student中的包含两个字段,整型的id,字符串型的name。只显示表student中name列记录的SQL语句正确的是() A: select name from student B: select * from student C: select from name in student D: select name
- 1
下列哪些SQL语句可以查询出User表中name为张三的记录()。 A: SELECT * FROM User WHERE name = ’张三’ B: SELECT * FROM User WHERE name = ’张三’ LIMIT 0,1 C: SELECT * FROM User WHERE name LIKE ’张三’ D: SELECT * FROM User WHERE name LIKE ’%张三%’
- 2
输出公司的名称及id,以id的升序排列 A: SELECT name, id FROM job ORDER BY id ASC; B: SELECT name, id FROM job ORDER BY id DESC; C: SELECT name, id FROM job ORDER BY name DECS; D: SELECT name, id FROM job ORDER BY name ASC;
- 3
在tb_name表中创建一个名为name_view的视图,并设置视图的属性为name、pwduser,执行语句是什么?( ) A: CREATE VIEW name_view(name,pwd,user)AS SELECT name.pwd,user FROM tb_mame; B: SHOW VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame: C: DROP VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame: D: SELECT * FROM name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_ name:
- 4
下面哪一个语句,显示没有Email地址的教师姓名() A: Select name from teacher where email=NULL; B: Select name from teacher where email C: Select name from teacher where email is NULL; D: Select name from teacher where emailis not NULL;