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
答案解析:有

微信扫一扫手机做题