[SQL] 어떻게 SQL 액세스 데이터베이스 테이블의 11 항목을 찾는 방법은?

어떻게 SQL 액세스 데이터베이스 테이블의 11 항목을 찾는 방법은?

어떻게 액세스 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;

해결법

1. ==============================

   1.당신은 하위 쿼리를 사용할 수 있습니다 :

   당신은 하위 쿼리를 사용할 수 있습니다 :

   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
   

2. ==============================

   2.

   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 LIMIT 1;
   

from https://stackoverflow.com/questions/44891320/how-to-find-11th-entry-in-sql-access-database-table by cc-by-sa and MIT license