如何在已选定字段时选择顶部

Question

只是想问一下，如果我已经从列表中选择了字段，那么如何添加'select top 1 *‘呢？我在其他代码中见过例子，但不太明白。如果在我构造的代码中看到它，思想就会更容易。

下面是我的一个查询示例：

select frp.ProductPersonID,frp.FlightSeatId, frp.PlusMealId,  per.TitleID,  per.surname,  per.FirstName, per.PersonTypeId, tor.PersonID, tor.Reference
from package pk 
        inner join product p  on p.packageid = pk.packageid
        inner join productperson pp on pp.productid = p.productid
        inner join person per on per.personid = pp.personid 
        left join flightlogicalseat fls on fls.productpersonid = pp.productpersonid
        inner join TourOperatorReference tor  on tor.PersonID = per.PersonId 
        inner join FlightReservationPassenger frp on frp.ProductPersonID = pp.ProductPersonId
where pk.Reference LIKE '%'
and ProductTypeId =1

Answer 1

只需尝试像这样使用顶关键字：

select TOP 1 frp.ProductPersonID,frp.FlightSeatId, frp.PlusMealId,  per.TitleID,

Answer 2

您只需将现有查询包装在新查询中：

SELECT TOP 1 * FROM
(select frp.ProductPersonID,frp.FlightSeatId, frp.PlusMealId,  per.TitleID,  per.surname,  per.FirstName, per.PersonTypeId, tor.PersonID, tor.Reference
from package pk 
        inner join product p  on p.packageid = pk.packageid
        inner join productperson pp on pp.productid = p.productid
        inner join person per on per.personid = pp.personid 
        left join flightlogicalseat fls on fls.productpersonid = pp.productpersonid
        inner join TourOperatorReference tor  on tor.PersonID = per.PersonId 
        inner join FlightReservationPassenger frp on frp.ProductPersonID = pp.ProductPersonId
where pk.Reference LIKE '%'
and ProductTypeId =1) t