求一条SQL语句 - MS-SQL Server / 基础类

表名news 字段ID,TITLENAME 
字段ID值为 1, 4, 6, 7, 8
现在我要求一条SQL语句得到前三行语句的第三行记录 也就是ID是6的语句.select top 1 * from news order by id desc 还有TOP 3（前三行) 如何录入 ；毕竟我遇到的问题是ID是不知道的参数；并且只取一行记录;

---

SQL code:
declare @n int
set @n=3
select top 1 * from(select top (@n) * from news order by id) a

---

SQL code:
declare @n int
set @n=3

print('select top 1 * from(select top '+ltrim(@n)+' * from news order by id) a')

---

SQL code:
--2000
declare @n int
set @n=3
print('select top 1 * from(select top '+ltrim(@n)+' * from news order by id) a order by id desc')


--2005
declare @n int
set @n=3
select top 1 * from(select top (@n) * from news order by id) a order by id desc

---

SQL code:
create proc Id_proc
declare @id int
as
begin
select top 1 * from news where ID not in (select top (@n-1) ID from news)
end
--应用：
exec Id_proc 3

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (fr