Select top 1 * from (select top n * from table) order by 主键ID desc
若选择前4条记录,SQL语句依次为: Select top 1 * from (select top n * from table) order by 主键ID desc Select top 2 * from (select top n * from table) order by 主键ID desc Select top 3 * from (select top n * from table) order by 主键ID desc Select top 4 * from (select top n * from table) order by 主键ID desc 是这样?
Select top 1 * from (select top n * from table) order by 主键ID desc
Select top 2 * from (select top n * from table) order by 主键ID desc
Select top 3 * from (select top n * from table) order by 主键ID desc
Select top 4 * from (select top n * from table) order by 主键ID desc
是这样?