当前位置: X题卡 > 所有题目 > 题目详情

对于图书管理数据库,分别求出各个单位当前借阅图书的读者人次。下面的SQL语句正确的是______。 SELECT 单位,______FROM 借阅,读者WHERE; 借阅.借书证号=读者.借书证号

查看本题答案

你可能感兴趣的试题

COUNT(借阅.借书证号)GROUP BY单位  SUM(借阅.借书证号)GROUP BY单位  COUNT(借阅.借书证号)ORDER BY单位  COUNT(借阅.借书证号)HAVING单位  
COUNT(借阅.借书证号) GROUPBY单位  SUM(借阅.借书证号) GROUPBY单位  COUNT(借阅,借书证号)ORDER BY单位  COUNT(借阅,借书证号).HAVING单位  
COUNT(借阅.借书证号)GROUP BY单位  SUM(借阅.借书证号)GROUP BY单位  COUNT(借阅.借书证号)ORDER BY单位  COUNT(借阅.借书证号)HAVING单位  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY单位  COUNT(借阅.借书证号) HAVING单位  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号)  GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY单位  COUNT(借阅.借书证号) HAVING单位  设有图书管理数据库:  图书(总编号C(6),分类号C(8),书名C(16),作者C(6),出版单位C(20),单价N(6,2))  读者(借书证号C(4),单位C(8),姓名C(6),性别C(2),职称C(6),地址C(20))  借阅(借书证号C(4),总编号C(6),借书日期D(8)).  (26)-(30)基于以上图书管理数据库。  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY 单位  COUNT(借阅.借书证号) HAVING 单位  
COUNT(借阅.借书证号) GROUPBY单位  SUM(借阅.借书证号) GROUPBY单位  COUNT(借阅,借书证号)ORDER BY单位  COUNT(借阅,借书证号).HAVING单位  
COUNT(借阅.借书证号) GROUP BY单位  SUM(借阅.借书证号) GROUP BY单位  COUNT(借阅.借书证号) ORDER BY单位  COUNT(借阅.借书证号) HAVING单位  
COUNT(借阅.借书证号) GROUP BY单位  SUM(借阅.借书证号) GROUP BY单位  COUNT(借阅.借书证号) ORDER BY单位  COUNT(借阅.借书证号) HAVING单位  
COUNT(借阅.借书证号)GROUP BY单位  SUM(借阅.借书证号)GROUP BY单位  COUNT(借阅.借书证号)ORDER BY单位  COUNT(借阅.借书证号)HAVING单位  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY单位  COUNT(借阅.借书证号) HAVING单位  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY 单位  COUNT(借阅.借书证号) HAVING 单位  
COUNT(借阅.借书证号)GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY 单位  COUNT(借阅.借书证号) HAVING 单位  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY 单位  COUNT(借阅.借书证号) HAVING 单位  
COUNT(借阅.借书证号)GROUP BY单位  SUM(借阅.借书证号)GROUP BY单位  COUNT(借阅.借书证号)ORDER BY单位  COUNT(借阅.借书证号)HAVING单位  
COUNT(借阅.借书证号)GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY 单位  COUNT(借阅.借书证号) HAVING 单位  
COUNT(借阅.借书证号) GROUP BY单位  SUM(借阅.借书证号) GROUP BY单位  COUNT(借阅.借书证号) ORDER BY单位  COUNT(借阅.借书证号) HAVING单位  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY 单位  COUNT(借阅.借书证号) HAVING 单位  
COUNT(借阅.借书证号) GROUP BY 单位  SUM(借阅.借书证号) GROUP BY 单位  COUNT(借阅.借书证号) ORDER BY 单位  COUNT(借阅.借书证号) HAVING 单位  
COUNT(借阅.借书证号)GROUP BY单位  SUM(借阅.借书证号)GROUP BY单位  COUNT(借阅.借书证号)ORDER BY单位  COUNT(借阅.借书证号)HAVING单位  

热门试题

更多