试题详情
- 单项选择题 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
关注下方微信公众号，在线模考后查看
热门试题