學習Microsoft SQL Server 2008技術內幕：T-SQL文法基礎--第4章

標籤：

第4章 子查詢

4.2.1 Exist 謂語：

use TSQLFundamentals2008select * from Sales.Customers as Cwhere c.country=N‘Spain‘select * from Sales.Customers as Cwhere c.country=N‘Spain‘ and exists(select * from Sales.Orders as O where o.custid=C.custid)select * from Sales.Customers as Cwhere c.country=N‘Spain‘ and not exists(select * from Sales.Orders as O where o.custid=C.custid)

View Code

 

 4.3.2 連續聚和

select OBJECT_ID(‘Sales.OrderTotalsByYear‘)if OBJECT_ID(‘Sales.OrderTotalsByYear‘) is not null  drop view Sales.OrderTotalsByYeargocreate view Sales.OrderTotalsByYear with schemabinding as   select     YEAR(o.orderdate) as orderyear,    SUM(od.qty) as qty    from   Sales.Orders as o    join Sales.OrderDetails as od on o.orderid=od.orderid  group by YEAR(o.orderdate)go

View Code

 

學習Microsoft SQL Server 2008技術內幕：T-SQL文法基礎--第4章