2013年6月21日
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 阅读(206) 评论(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 阅读(251) 评论(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 阅读(541) 评论(0) 推荐(0) 编辑