Sql Top急求!!!!! [英] Sql Top urgent help !!!!!

问题描述

我需要使用多个顶部



示例

i need use multiple top

example

Select top 5  OrderID from Orders where ShipVia in
(Select ShipperID from Shippers where CompanyName = 'Speedy Express' and CompanyName = 'United Package')

i需要前5名Speedy Express和前5名United Package订单

i need top 5 Speedy Express and top 5 United Package orders

推荐答案

这将帮助你.....

This Will Help you.....

SELECT * FROM (
SELECT top 5  OrderID FROM Orders WHERE ShipVia IN
(SELECT ShipperID FROM Shippers WHERE CompanyName = 'Speedy Express' )

UNION ALL


SELECT top 5  OrderID FROM Orders WHERE ShipVia IN
(SELECT ShipperID FROM Shippers WHERE  CompanyName = 'United Package')) AS Tbl1

这篇关于Sql Top急求!!!!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！