ÇóÒ»Ìõ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ÊDz»ÖªµÀµÄ²ÎÊý£»²¢ÇÒֻȡһÐмǼ;

---

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