如何在 SQL Access 数据库表中找到第 11 个条目? [英] How to find 11th entry in SQL Access database table?
本文介绍了如何在 SQL Access 数据库表中找到第 11 个条目?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在 Access SQL 数据库表中找到第 11 个条目?我必须使用 TOP 函数,我的查询目前看起来像这样:
How would I find the 11th entry in an Access SQL database table? I have to use the TOP function, and my query currently looks like this:
SELECT TOP 11 Passenger.Name, SUM(Manifest.Ticketprice) AS [Total Amount Spent on Tickets]
FROM Passenger INNER JOIN Manifest ON Passenger.PassengerNumber=Manifest.PassengerNumber
GROUP BY Passenger.Name
ORDER BY SUM(Manifest.Ticketprice) DESC;
推荐答案
您可以使用子查询:
SELECT TOP 1 T.Name, T.[Total Amount Spent on Tickets]
FROM
(SELECT TOP 11 Passenger.Name, SUM(Manifest.Ticketprice) AS [Total Amount Spent on Tickets]
FROM Passenger INNER JOIN Manifest ON Passenger.PassengerNumber=Manifest.PassengerNumber
GROUP BY Passenger.Name
ORDER BY SUM(Manifest.Ticketprice) DESC) As T
ORDER BY T.[Total Amount Spent on Tickets] ASC
这篇关于如何在 SQL Access 数据库表中找到第 11 个条目?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文