考虑这样一个问题,库存量最大的商品或者库存量最小的商品都不止一个,同时取出它们信息,怎么取呢?
- select [ProductID] ,[ProductName],[UnitsInStock]
- from [Products] p where p.[UnitsInStock] = ( select max( [UnitsInStock] ) from [Products] p1)
- union all
- select [ProductID] ,[ProductName],[UnitsInStock]
- from [Products] p where p.[UnitsInStock] = ( select min( [UnitsInStock] ) from [Products] p2)