Question

sql取第二条记录怎么取

select top 1 N_picurl from BQ_News 这是取第一条记录第二条呢？咋取？

Answer 1

先去两条记录，再倒序取第一条。

Answer 2

第一种方法在sql2000中不能用。要2005以上才可以

Answer 3

SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY keyField DESC) AS rowNum, * FROM BQ_News) AS t WHERE rowNum=2

Answer 4

select top 1 * from (select top 2 * from tb order by ortfield desc)

Answer 5

select top 1 * from table where id not in (select top 1 id form table) 也可以