accessÈ¥³ýÖظ´¼Ç¼,ÔÚÏßµÈ,ллÁË

±íproducts
±íxl
ÏÖÔÚÎÒÏë¶ÁÈ¡xlÀïÃæµÄ10Ìõ¼Ç¼,µ«ÊÇxl_idÒªµÈÓÚproducts±íÀïµÄp_xlid,²¢ÇÒp_xlidֻȡproductsÀïÃæµÄÒÔp_browsecount  DESCÅÅÐòµÄÇ°10Ìõ
ÎÒÓõÄÕâ¸öÈ¡³öÀ´ÓÐÖظ´¼Ç¼
SELECT TOP 10 xl_info.xl_id,xl_info.xl_name from products,xl_info WHERE (xl_info.xl_id=products.p_xlid) ORDER BY products.p_browsecount DESC

---

SELECT distinct TOP 10 xl_info.xl_id,xl_info.xl_name from products,xl_info WHERE (xl_info.xl_id=products.p_xlid) ORDER BY products.p_browsecount DESC

---

select  *  from  ±íÃû  where  name  in  (select  name  from  ±íÃû  having  count(name)>1)

---

¼Ó¹Ø¼ü×Ö distinct

---

Òì³£ÏêϸÐÅÏ¢: System.Data.OleDb.OleDbException: ORDER BY ×Ó¾äÓë (products.p_browsecount)  DISTINCT ³åÍ»¡£

---

ÓÃÄÚÁ¬½Ó°¡£¡£¡£¡ÓÃÄÚÁ¬½Ó¾ÍûÓÐÖظ´µÄÁË
SQL code:

select top 10 b.xl_id,b.xl_name
from products as a inner JOIN xl_info as b
ON b.xl_id=a.p_xlid) ORDER BY a.p_browsecount DESC


-.-!

---

SQL code:

select top 10 b.xl_id,b.xl_name
from products as a inner JOIN xl_info as b
ON b.xl_id=a.p_xlid ORDER BY a.p_browsecount DESC


-.-!Õâ¸ö¡£¡£

---

SQL code

---

Code highlighting pro