多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

Given the following function: CREATE FUNCTION emplist ( ) RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

  • A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
  • B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
  • C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
  • D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题