Use query in where clause : Where « Select Query « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Select Query
3. Where

Use query in where clause

 



2> CREATE TABLE Orders (
3>      OrderID int NOT NULL ,
4>      CustomerID nchar (5) NULL ,
5>      EmployeeID int NULL ,
6>      OrderDate datetime NULL ,
7>      RequiredDate datetime NULL ,
8>      ShippedDate datetime NULL ,
9>      ShipVia int NULL ,
10>     Freight money NULL DEFAULT (0),
11>     ShipName nvarchar (40) NULL ,
12>     ShipAddress nvarchar (60) NULL ,
13>     ShipCity nvarchar (15) NULL ,
14>     ShipRegion nvarchar (15) NULL ,
15>     ShipPostalCode nvarchar (10) NULL ,
16>     ShipCountry nvarchar (15) NULL
17> )
18> GO
1>
2>    SELECT o1.CustomerID, o1.OrderID, o1.OrderDate
3>    FROM Orders o1
4>    WHERE o1.OrderDate = (SELECT Min(o2.OrderDate)
5>                          FROM Orders o2
6>                          WHERE o2.CustomerID = o1.CustomerID)
7>    ORDER BY CustomerID
8> GO
CustomerID OrderID     OrderDate
---------- ----------- -----------------------

(0 rows affected)
1>
2> drop table orders;
3> GO

 

Related examples in the same category