06 2013 档案

Subqueries: Any/All
摘要：1. Subquery Any Syntax: -- any-- remove inner order byselect EnglishProductName, ListPrice from DimProductwhere ListPrice > any(select avg(ListPrice) from DimProductgroup by ProductSubcategoryKey... 阅读全文
posted @ 2013-06-21 17:18 AOT 阅读(212) 评论(0) 推荐(0)
Except/Intersect/Union
摘要：1. Union Syntax: -- union 10 recordsselect * from Table1unionselect * from Table2--select EnglishProductName from Table1unionselect EnglishProductName from Table2Analysis:You can union more than ... 阅读全文
posted @ 2013-06-21 15:48 AOT 阅读(271) 评论(0) 推荐(0)
Local vs Global Temporary Table
摘要：1. Local temporary table Syntax: -- local temporaryselect EnglishProductName, ListPrice - DealerPrice as Discount into #NewDimProductfrom DimProductwhere ListPrice - DealerPrice is not nullorder ... 阅读全文
posted @ 2013-06-21 14:21 AOT 阅读(557) 评论(0) 推荐(0)