CREATE TABLE [dbo].[emp_pay](    [employeeID] [int] NOT NULL,    [base_pay] [money] NOT NULL,    [commission] [decimal](2, 2) NOT NULL) ON [PRIMARY]

--方法一select top 1 * from(        SELECT TOP 2 *    FROM [dbo].[emp_pay]    WHERE  base_pay = 500    order by employeeID ASC) as a  --注意：派生表后面一定要指定别名．order by a.employeeID DESC

--方法二select IDENTITY(int,1,1) ID,* INTO #Temp from [dbo].[emp_pay] where base_pay = 500select * from #Temp where ID =2drop Table #Temp

--方法三set rowcount 2SELECT * into #t from [dbo].[emp_pay] where base_pay = 500set rowcount 1delete from #tselect * from #tset rowcount 0drop table #t