你可能感兴趣的试题
MAX(单价)，MIN(单价)，AVG(单价) MAX(单价)，MIN(单价)，AVERAGE(单价) MAX(单价)，MIX(单价)，AVG(单价) MAX(单价)，SUM(单价)，AVG(单价)
MAX(单价)，M1N(单价)，AVG(单价) MAX(单价)，MIN(单价)，AVERAGE(单价) MAX(单价)，MIX(单价)，SUM(单价) MAX(单价)，SUM(单价)，AVG(单价)
MIN(单价) AVGAGE(单价) COUNT(*) GROUPBY MAX(单价) AVG(单价) COUNT(*) ORDERBY MAX(单价) AVG(单价) SUM(*) ORDERBY MAX(单价) AVG(单价) COUNT(*) GROUPBY
MIN(单价) AVGAGE(单价) COUNT(*) GROUPBY MAX(单价) AVG(单价) COUNT(*) ORDERBY MAX(单价) AVG(单价) SUM(*) ORDERBY MAX(单价) AVG(单价) COUNT(*) GROUPBY
GROUP BY单价DESC ORDER BY单价DESC ORDER BY单价ASC GROUP单价ASC
MAX(单价)，MIN(单价)，AVG(单价) MAX(单价)，MIN(单价)，AVERAGE(单价) MAX(单价)，MIX(单价)，AVG(单价) MAX(单价)，SUM(单价)，AVG(单价)
GROUP BY单价DESC ORDER BY单价DESC ORDER BY单价ASC GROUP单价ASC
MAX(单价)，MIN(单价)，AVG(单价) MAX(单价)，MIN(单价)，AVERAGE(单价) MAX(单价)，MIX(单价)，SUM(单价) MAX(单价)，SUM(单价)AVG(单价)
MAX(单价)，M1N(单价)，AVG(单价) MAX(单价)，MIN(单价)，AVERAGE(单价) MAX(单价)，MIX(单价)，SUM(单价) MAX(单价)，SUM(单价)，AVG(单价)
对于图书管理数据库，求电子工业出版社出版图书的最高单价、最低单价和平均单价。下面SQL语句正确的是________。
SELECT ______ FROM 图书;
WHERE 出版单位="电子工业出版社" MAX(单价),MIN(单价),AVERAGE(单价) MAX(单价),MIX(单价),AVG(单价) MAX(单价),SUM(单价),AVG(单价)
MAX(单价)，MIN(单价)，AVG(单价) MAX(单价)，MIN(单价)，AVERAGE(单价) MAX(单价)，MIX(单价)，AVG(单价) MAX(单价)，SUM(单价)，AVG(单价)
MAX(单价)，MIN(单价)，AVG(单价) MAX(单价)，MIN(单价)，AVERAGE(单价) MAX(单价)，MIX(单价)，AVG(单价) MAX(单价)，SUM(单价)，AVG(单价)
GROUP BY 单价 DESC ORDER BY 单价 DESC ORDER BY 单价 ASC ORDER BY 单价 ASC
湘公网安备 43130202000226号