SQL Select notes
We can figure out the difference in three expressions: (Sum(),Compute ,Cube) bytwo select statement.CASE1USE pubs SELECT SUBSTRING(title, 1, 65) AS title, SUM(qty) AS 'qty' FROM sales INNER JOIN titles ON sales.title_id = titles.title_id GROUP BY title WITH CUBE ORDER BY title 下面是结果集:……