Inside SQL Server 2005 T-SQL Querying 学习笔记
文章平均质量分 80
Allanxl
这个作者很懒,什么都没留下…
展开
-
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 · 1066 阅读 · 0 评论 -
Inside Microsoft SQL Server 2005:T-SQL Querying (查询处理的数据流程|第二章)
在SQL Server Management Studio(SSMS)中查询 USE Northwind;SELECT C.CustomerID, COUNT(O.OrderID) AS NumOrdersFROM dbo.Customers AS C LEFT OUTER JOIN dbo.Orders AS O ON C.CustomerID = O.CustomerIDWHERE C.City = 'London'GROUP BY C.CustomerIDHA原创 2011-03-24 15:49:00 · 1088 阅读 · 0 评论