¹ØÓÚSQLÎÊÌâ - .NET¼¼Êõ / ASP.NET

ÓÐÕâÑùÒ»¸ö±í£¬±íÀïÓÐÂÛ̳ID£¬Óû§Ãû³ÆÕâÁ½¸ö×Ö¶Î

bid userid
1068 º®ÑÌ´äºþÖ÷
1068 »Û×Ó
1068 ½ðɽÀË×Ó
1068 Íü³¾·ãÁÖ
1068 Ñï~~·ç~~
1091 dawei
1091 yaoyuan
1091 °×Ðõ
............
select count(userid) from B_Users where bid='1068' £¬Ä¿Ç°Í¨¹ýÕâ¾äÖ»Äܲéѯµ¥¸öÂÛ̳µÄ³ÉÔ±Êý
ÎÒÏëÏÔʾǰ10µÄ×îÊÜ»¶Ó­ÂÛ̳µÄÅÅÐУ¬ÇëÎÊÔõôʵÏÖÄØ£¬Ò²¾ÍÊÇ˵¸ù¾Ý³ÉÔ±Êý×î¶àµÄÅÅÐò£¬ÏÔʾÂÛ̳³öÀ´

---

top?

---

SQL code:

select top 10 * from(select count(userid),bid from B_Users group by bid order by count(userid) desc)

---

select top 10 * from(select count(userid),bid from B_Users group by bid order by count(userid) desc)
¶¥£¡£¡

---

SELECT Top 10 bid ,count(userid) from B_Users
group by bid

---

select top 10 * from(select count(userid),bid from B_Users group by bid order by count(userid) desc)

---

select top 10 * from(select count(userid),bid from B_Users group by bid order by count(userid) desc)
Õâ¾äÔËÐÐÁË ±¨ÕâÑùµÄ´íŶ
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

---

ÊÇµÄ top10¿ÉÒÔ

---

ÒýÓÃ

top?

Èç´ËÈç´Ë ¡¢Õâ°ãÕâ°ã

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.Cod