case when then 用在条件判断上

SELECT [OrderID] ,[CustomerID] ,[EmployeeID] ,[OrderDate] ,[RequiredDate] ,[ShippedDate] ,[ShipVia] ,[Freight] ,[ShipName] ,[ShipAddress] ,[ShipCity] ,[ShipRegion] ,[ShipPostalCode] ,[ShipCountry] FROM [Northwind].[dbo].[Orders] where case when [CustomerID]='VINET' then [EmployeeID] end >1

posted @ 2010-10-19 21:11  0707  阅读(221)  评论(0编辑  收藏  举报