¼¸µÀ¾­µäµÄsqlÌâÄ¿

£¨1£©±íÃû£º¹ºÎïÐÅÏ¢
¹ºÎïÈË      ÉÌÆ·Ãû³Æ     ÊýÁ¿
A            ¼×          2
B            ÒÒ          4
C            ±û          1
A            ¶¡          2
B            ±û          5
……
£¨ÆäËûÓû§ÊµÑéµÄ¼Ç¼´ó¼Ò¿É×ÔÐвåÈ룩
¸ø³öËùÓйºÈëÉÌƷΪÁ½ÖÖ»òÁ½ÖÖÒÔÉϵĹºÎïÈ˼Ǽ
´ð£ºselect * from ¹ºÎïÐÅÏ¢ where ¹ºÎïÈË in (select ¹ºÎïÈË from ¹ºÎïÐÅÏ¢ group by ¹ºÎïÈË having count(*) >= 2);
ÎҵĴ𰸣º
SELECT *
from purchase t
WHERE ( select count(*)
from purchase s
where s.name = t.name
) >= 2
OR
select *
from purchase name in
( select name from purchase
group by name
having count(name) >= 2
)

£¨2£©±íÃû£º³É¼¨±í
ÐÕÃû   ¿Î³Ì       ·ÖÊý
ÕÅÈý     ÓïÎÄ       81
ÕÅÈý     Êýѧ       75
ÀîËÄ     ÓïÎÄ       56
ÀîËÄ     Êýѧ       90
ÍõÎå     ÓïÎÄ       81
ÍõÎå     Êýѧ       100
ÍõÎå     Ó¢Óï       49
……
£¨ÆäËûÓû§ÊµÑéµÄ¼Ç¼´ó¼Ò¿É×ÔÐвåÈ룩
¸ø³ö³É¼¨È«²¿ºÏ¸ñµÄѧÉúÐÅÏ¢£¨°üº¬ÐÕÃû¡¢¿Î³Ì¡¢·ÖÊý£©£¬×¢£º·ÖÊýÔÚ60ÒÔÉÏÆÀΪºÏ¸ñ
´ð£ºselect * f