【OCP-12c】CUUG最新考试原题整理及答案(071-9)
9、(5-5) choose the best answer
View the Exhibit and examine the structure of the SALES and STORES tables. You want to display the store name and the total quantity sold for each item in the store. Which SQL statement will give the required output? B) SELECT str.name,s1.items_id; C) SELECT str.name, D) SELECT str.name,SUM(s1.quantity) Answer:B(解析:分组函数的最基本特点,没有出现在分组函数中的列必须要出现在 group by 子句中。) (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |