这不就是 select top N id from table where id not in (select top M id from table) 问题吗?
select top 3 * from table order by id desc
--查询最大的 select top 1 * from ftp where ID not in (select top 0 ID from ftp order by FileSize desc) order by FileSize desc --查询最二大的 select top 1 * from ftp where ID not in (select top 1 ID from ftp order by FileSize desc) order by FileSize desc --查询第三大的 select top 1 * from ftp where ID not in (select top 1 ID from ftp order by FileSize desc) order by FileSize desc
--查询第三大的select top 1 * from ftp where ID not in (select top 2 ID from ftp order by FileSize desc) order by FileSize desc--刚才没注意了
row_num不就可以了Select * From(Select *,ROW_NUMBER() OVER(ORDER BY id DESC) as RowNum From tb) newtb where RowNum=2--这样就取出了第二大
在页面写FOR循环 想找第几个ID就IF()判断索引
select top 10 * from table1 order by id desc 按照id倒序排列 不就可以了么
如果需要n条
就top n
SELECT top 3 * FROM tb order by id desc
select top 3 * from tb order by id desc
select top N id from table
where id not in (select top M id from table)
问题吗?
--查询最大的
select top 1 * from ftp where ID not in
(select top 0 ID from ftp order by FileSize desc)
order by FileSize desc
--查询最二大的
select top 1 * from ftp where ID not in
(select top 1 ID from ftp order by FileSize desc)
order by FileSize desc
--查询第三大的
select top 1 * from ftp where ID not in
(select top 1 ID from ftp order by FileSize desc)
order by FileSize desc
(select top 2 ID from ftp order by FileSize desc)
order by FileSize desc--刚才没注意了
where RowNum=2--这样就取出了第二大