Given the following function:CREATE FUNCTION emplist ()RETURNS TABLE ( id CHAR(6), firstname VARCHAR(12), lastname VARCH
Posted: Fri Aug 26, 2022 9:58 am
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, LASTNAMEFROM 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
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