软件开发技术基础第2版课件作者赵英良第4章节数据库及应用程序开发2_SQL.pptVIP

按商店名称排序降序排序 SELECT stor_name, city FROM stores ORDER BY store_name DESC ?按商店名称排序升序排序 SELECT stor_name, city FROM stores ORDER BY store_name ASC */57 用多个列排列 SELECT stor_name, city FROM stores ORDER BY stor_name， city ?用不出现的列 SELECT stor_name, city FROM stores ORDER BY state */57 (6) 统计函数 计算图书的平均定价 SELECT AVG(price) FROM titles ?计算type=’business’的图书的最高价格 SELECT MAX(price) FROM titles WHERE type=’business’ */57 多个计算列用逗号隔开 SELECT AVG(qty), SUM(qty), COUNT(DISTICT stor_id) FROM sales ?统计满足条件的记录个数 SELECT COUNT（*） FROM publishers WHERE state=’CA’ */57 (7) 结果分组 GRO