当一个SQL语句存在where 、 group by 、order by 时，运行的顺序是怎么样的呢？ (8) SELECT (9) DISTINCT (11) <TOP_specification> <select_list> (1) from <left_table> (3) <join_type> JOIN <right_table> (2) ON <join_condition> (4) WHERE <where_condition> (5) GROUP BY <group_by_list> (6) WITH {CUBE | ROLLUP} (7) HAVING <having_condition> (10) ORDER BY <order_by_list>
数字就是顺序 WITH {CUBE | ROLLUP}这个是什么意思呢？ 学习
求总计、合计的 SQL code: ---------------------------------------------------------------- -- Author :fredrickhu(小F，向高手学习) -- Date :2009-09-03 19:50:10 -- Verstion: -- Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) -- Nov 24 2008 13:01:59 -- Copyright (c) 1988-2005 Microsoft Corporation -- Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3) -- ---------------------------------------------------------------- --> 测试数据：[tb] if object_id('[tb]') is not null drop table [tb] go create table [tb]([姓名]
