日期:2014-05-18 浏览次数:20468 次
declare @num as int select @num = count(*) from authors set @num = @num - 1 declare @sql as varchar(200) set @sql = 'select * from authors where au_id not in (select top ' + cast(@num as char) + ' au_id from authors)' exec (@sql)