sql²éѯÓï¾ä - MS-SQL Server / »ù´¡Àà

ÇóÒ»sqlÓï¾ä£º
²éѯһÊý¾Ý±íµÄ×îºóÊ®Ìõ¼Ç¼

---

select top 10 * from tb order by id desc

---

ÓÐʱ¼ä×ֶεĻ°
select top 10 * from tb order by ʱ¼ä×ֶΠdesc

---

ÒýÓÃ

ÓÐʱ¼ä×ֶεĻ°
select top 10 * from tb order by ʱ¼ä×ֶΠdesc

up

---

¿ÉÄÜÊÇÎÒû±í´ïÇå³þ~Õâ¸öÎÒÊÇд³öÀ´Á˵Ä~
µ«ÊÇÕâ¸öÊý¾Ý±íÏÔʾ³öÀ´µÄʱºòÒªÓÖÒªµ¹ÐòÏÔʾ`×îºóÒ»ÌõÊÇÔÚÁбíµÄ×îÏÂÃæ

---

SQL code:

select * from (
select top 10 * from tb order by ʱ¼ä×ֶΠdesc
) t order by ʱ¼ä×ֶΠASC

---

SQL code:
select *
from (
select rn=row_number()over(order by col desc),*
from tb
) t
where rn<=10
order by col

---

ÒýÓÃ

¿ÉÄÜÊÇÎÒû±í´ïÇå³þ~Õâ¸öÎÒÊÇд³öÀ´Á˵Ä~
µ«ÊÇÕâ¸öÊý¾Ý±íÏÔʾ³öÀ´µÄʱºòÒªÓÖÒªµ¹ÐòÏÔʾ`×îºóÒ»ÌõÊÇÔÚÁбíµÄ×îÏÂÃæ

2005¼°ÒÔÉÏ°æ±¾¿ÉÒԲο´6Â¥

---

2005ÒÔÉÏ

select * 
from (
  select rn=row_number()over(order by col desc),* 
  from tb
  ) t
where rn<=10
order by col

---

¸ã¶¨ÁË~~
лл¸÷λ~½áÌùÁË

---

up[Quote=ÒýÓà   2   Â¥   kerafan   µÄ»Ø¸´:]
ÓÐʱ¼ä×ֶεĻ°
select