Çë½ÌÒ»¸ösqlÓï¾ä·Ö×éÅÅÐòÎÊÌâ

ÎÒÏÖÔÚÓÐÕâÑùÒ»Õűí procucts,ÀïÃæÓÐproductname£¨ÉÌÆ·Ãû³Æ£©¡¢procuctprice(ÉÌÆ·¼Û¸ñ)¡¢cid(¹«Ë¾µÄid)

ÎÒÐèÒªµÃµ½Ã¿Ò»¸ö¹«Ë¾Öм۸ñ×î¸ßµÄÒ»Ìõ¼Ç¼£¨Ã¿¸ö¹«Ë¾Ö»ÒªÒ»Ìõ£©£¬È»ºó°´ÕÕ¼Û¸ñ´Ó¸ßµ½µÍµÄ˳ÐòÅÅÁУ¨Ã¿¸ö¹«Ë¾Ö»Óм۸ñ×î¸ßµÄÄÇÌõÄóöÀ´²ÎÓëÅÅÐò£©

×îºÃÄÜÓÃÒ»ÌõÓï¾äʵÏÖ£¬ÎҵľßÌåÓ¦ÓÃÒª¸ü¸´ÔÓÒ»ÏÂ

---

×îºÃÄÜÓÃÒ»ÌõÓï¾äʵÏÖ£¬ÎҵľßÌåÓ¦ÓÃÒª¸ü¸´ÔÓһЩ

---

SQL code:
SELECT * from TB T
WHERE NOT EXIXTS(SELECT 1 from TB WHERE cid=T.cid AND procuctprice>T.procuctprice)

---

ÒýÓÃ

SQL codeSELECT*from TB TWHERENOT EXIXTS(SELECT1from TBWHERE cid=T.cidAND procuctprice>T.procuctprice)

SQL code:
--¼ÓÉÏÅÅÐò
SELECT * from TB T
WHERE NOT EXIXTS(SELECT 1 from TB WHERE cid=T.cid AND procuctprice>T.procuctprice)
ORDER BY procuctprice DESC

---

SQL code:
select a.* from procucts a
where not exists
(select 1 from procucts where cid=a.cid and procuctprice>a.procuctprice)
order by a.procuctprice desc

---

SQL code

---

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

--