- 博客(2)
- 资源 (1)
- 收藏
- 关注
原创 Inside Microsoft SQL Server 2005:T-SQL Querying (查询处理的数据流程|第二章)
在SQL Server Management Studio(SSMS)中查询 USE Northwind; SELECT C.CustomerID, COUNT(O.OrderID) AS NumOrders FROM dbo.Customers AS C LEFT OUTER JOIN dbo.Orders AS O ON C.CustomerID = O.CustomerID WHERE C.City = 'London' GROUP BY C.CustomerID HA
2011-03-24 15:49:00 1097
原创 Inside Microsoft SQL Server 2005:T-SQL Querying (逻辑查询处理顺序|第一章)
如下所示SQL语句展示了逻辑查询的处理顺序 (8) SELECT (9) DISTINCT (11) (1) FROM (3) JOIN (2) ON (4) WHERE (5) GROUP BY (6) WITH {CUBE | ROLLUP} (7) HAVING (10) ORDER BY 步骤1 FROM:查询语句中from语句中的两个表进行交叉连接,生成虚拟表V1 步骤2 ON:筛选器ON应用到V1上,并把满足条件的行插
2011-03-22 07:26:00 1069
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人