当前位置: 答题翼 > 问答 > 计算机类考试 > 正文
目录: 标题| 题干| 答案| 搜索| 相关
问题

Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) first


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‘); ENDHow 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

参考答案
您可能感兴趣的试题
  • The signs or cues of culture shock given by the author involve all of the following EXCEPT

  • All of the following statements are correct EXCEPT that______.A.the statement is given by

  • Which of the following is NOT the reason given in the passage for people to avoid discussi

  • Which of the following advice is NOT given about the womans purse?A.Mending the hole in th

  • Which of the following is false according to the information given in the passage?A.Fashio

  • Directions: Read the following passage. Answer the questions according to the information given in t