SELECT TOP 5 orderid,productid, quantity
FROM [order details]
ORDER BY quantity DESC
GO
或
SELECT TOP 5 WITH TIES orderid,quantity
FROM [order details]
ORDER BY quantity DESC
GO
...全文
14212打赏收藏
取出数据库中前五为数据的代码!!
有谁用过如下(在JSP中) SELECT TOP 5 orderid,productid, quantity FROM [order details] ORDER BY quantity DESC GO 或 SELECT TOP 5 WITH TIES orderid,quantity FROM [order details] ORDER BY quantity DESC GO