The SQL statement queries the method of the second record that matches the condition in the table

SQL to create the table used

CREATE TABLE [dbo]. [Emp_pay] (    [EmployeeID] [int] NOT NULL,    [Base_pay] [money] is not NULL,    [commission] [Decimal] (2, 2) is not null) on [PRIMARY ]

The resulting table, and the data in the table:

--Method OneSelect Top 1 *  from(        SELECT TOP 2 *     from [dbo].[Emp_pay]    WHEREBase_pay=  -    Order  byEmployeeIDASC) asA--Note: Be sure to specify an alias after the derived table. Order  byA.employeeidDESC

--Method TwoSelect IDENTITY(int,1,1) ID,*  into#Temp  from [dbo].[Emp_pay] whereBase_pay=  -Select *  from#Temp whereId=2Drop Table#Temp

--Method ThreeSet RowCount 2SELECT *  into#t from [dbo].[Emp_pay] whereBase_pay=  -Set RowCount 1Delete  from#tSelect *  from#tSet RowCount 0Drop Table#t

The SQL statement queries the method of the second record that matches the condition in the table