SQLÓï¾äÎÊÌâ

ÎÒÓÐÒ»¸ö±í,±íÀïÃæÓиö×Ö¶Î"ÊýÁ¿",Ôõô»ñÈ¡"ÊýÁ¿"×î´óµÄ5¸öÊý¾Ý???

---

SQL code:
select top 5 ÊýÁ¿ from ±í order by ÊýÁ¿ desc

---

select top 5 * from tb order by ÊýÁ¿ desc

---

ÒýÓÃ

select top 5 * from tb order by ÊýÁ¿ desc

»¹ÓÐÆäËûÓï¾äÂð...

---

ÒýÓÃ

SQL codeselecttop5 ÊýÁ¿from ±íorderby ÊýÁ¿desc

up

---

ºÃÏñûÓÐÁË¡¡¡¡¡¡¡¡¡¡¡£

---

SQL code:
declare @i int
select @i=max(數Á¿)from tb
set rowcount 5
select * from tb where 數Á¿<=@i order by 數Á¿ desc
set rowcount 0

---

select top 5 ÊýÁ¿ from ±í order by ÊýÁ¿ desc

---

ÒýÓÃ

SQL codedeclare@iintselect@i=max(數Á¿)from tbsetrowcount5select*from tbwhere 數Á¿<=@iorderby 數Á¿descsetrowcount0

SQL code:

select top 5 from tb order by quantity desc

---

declare @i int
select @i=max(數Á¿)from tb
set rowcount 5
select * from tb where 數Á¿<=@i order by 數Á¿ desc
set rowcount 0

---