单选题
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?
发布日期：2022-07-20
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
标签： "暂无标签"
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在