A. SELECT @courseid AS ’206’ B. SET @courseid = ’206’ C. @courseid = ’206’ D. SET @courseid AS ’206’
A. SELECT @courseid = 課程號 FROM XSB WHERE 課程名 = ’計(jì)算機(jī)基礎(chǔ)’ B. SELECT 課程號 AS @courseid FROM XSB WHERE課程名= ’計(jì)算機(jī)基礎(chǔ)’ C. SELECT @courseid = (SELECT 課程號 FROM XSB WHERE課程名 = ’計(jì)算機(jī)基礎(chǔ)’) D. SET @courseid = (SELECT 課程號 FROM XSB WHERE課程名= ’計(jì)算機(jī)基礎(chǔ)’)
根據(jù)XSB來建立一個(gè)每個(gè)專業(yè)中年齡最小者的NLZX視圖,該視圖包含“專業(yè)”及其“最晚出生日期”兩列,對應(yīng)的SQL語句為CREATE VIEW NLZX AS ___①___ 其中空項(xiàng)部分的內(nèi)容應(yīng)為語句為()
A. SELECT 專業(yè), MAX(出生時(shí)間) AS 最晚出生日期 FROM XSB GROUP BY 專業(yè) B. SELECT 專業(yè), MIN(出生時(shí)間) AS 最晚出生日期 FROM XSB GROUP BY 專業(yè) C. SELECT 專業(yè), MIN(出生時(shí)間) AS 最晚出生日期 FROM XSB GROUP BY出生時(shí)間 D. SELECT 專業(yè), MAX(出生時(shí)間) AS 最晚出生日期 FROM XSB GROUP BY出生時(shí)間