• 2022-11-04
    引用集合数据类型中的元素选择sub数组中第一个元素进行查询,正确的是( )
    A: select name,subordinates[0] from emplyees;
    B: select name,subordinates[1] from emplyees;
    C: select name,subordinates from emplyees;
    D: 以上都不正确
  • A
    本题目来自[网课答案]本页地址:https://www.wkda.cn/ask/exppjapmzpppmxoo.html

    内容

    • 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;