SQLÓï¾ä,²»ÖªÊDz»ÊÇÄѵã

ÎÊÒ»MSSQLÓï¾ä,ÕÒÒ»ID(Ö÷¼ü)µÄÇ°ºóËÄÌõÊý¾Ý,Èç:IDÊÇ5¾ÍµÃµ½1234,6789
Èç:IDÊÇ1,¾ÍÕÒ2345,ºóÒ²ÊÇÒ»Ñù

---

SQL code:
select top 4 * from tb order by ID desc
select top 4 * from tb order by ID asc

---

Èç¹ûСÓÚ4ÌõÄØ£¿

---

ID ÊÇ·ñ連續?

---

ÒýÓÃ

ÎÊÒ»MSSQLÓï¾ä,ÕÒÒ»ID(Ö÷¼ü)µÄÇ°ºóËÄÌõÊý¾Ý,Èç:IDÊÇ5¾ÍµÃµ½1234,6789
Èç:IDÊÇ1,¾ÍÕÒ2345,ºóÒ²ÊÇÒ»Ñù

SQL code:
select id from
(
select * , px = (select count(1) from tb where id < t.id) + 1 from tb t
) m
where id = 5 and abs(px - 4) between 1 and 4

---

SQL code:
select top 4 * from(select top 4 * from tb order by ID desc)a
union all
select top 4 * from tb order by ID asc

---

´óÎÚ¹êºÍαAMM¶¼¶Ô£¬²»¹ý¸Ð¾õ´óÎÚ¹êµÄÓò»µ½Ë÷Òý

---

ÒªÊÇÓù¦Ñ§Ï°¶¼ÄÜѧ»á

---

SQL code:
declare @i int
set @i=5
select * from ±í T where abs((select count(1) from TB where T.id>=id)-5)<=4

---

yes£¬Óù¦Ñ§Ï°

---

ѧϰ

---

SQL code

---

Code highlighting