如何在Access sql数据库表中找到第11个条目？我必须使用TOP函数,我的查询目前看起来像这样：
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
