ÇóÒ»¸ö¹ØÓÚ¹ýÂ˵ÄSQLÓï¾ä

±íÈçÏÂ
A B C
Ǧ±Ê 3 1
ë±Ê 3 4
Ô²Öé±Ê 5 1
Ô²Öé±Ê 5 6
ÎÒÒª¹ýÂ˵ôÏàͬ¼Ç¼µÄ×éÈçµÚ3ºÍµÚ4Ìõ¼Ç¼£¬Èç¹ûÓÃͨÅä·û£¨ Ô²%£© ÔõÑùд°¡£¬Ð»Ð»¸÷λÁË£¡

---

ÏëµÃµ½Ê²Ã´½á¹û

---

SQL code:
SELECT A,B,MAX(C)C from TB GROUP BY A,B

---

SQL code:

select * from tb
where A not like 'Ô²%'

---

SQL code:
select * from tb
where A in
(select A from tb group by A having count(1) = 1)

---

SQL code:

select * from TB T,
(
SELECT A,Count(A) from TB group by A having Count(A) >1
)
T1 where T.A <> T1.A

---

¶¼ÔÚ´§²âÊ¥Òâ¡­¡­ºÇºÇ

---

Äã²»»áÊÇÐèÒªÕâ¸ö°Ñ¡£

SQL code:
select * from TB where A not in(select A from TB where A like 'Ô²%' )

---

ÒýÓÃ

Äã²»»áÊÇÐèÒªÕâ¸ö°Ñ¡£

SQL codeselect*from TBwhere Anotin(sel