|
|
|
|
如何从表中选择重复的记录http://www.xishui.net 2004年12月06日13:17 浠水网
SELECT * FROM table A WHERE EXISTS ;
(SELECT * FROM table B WHERE B.key = A.key; GROUP BY key ; HAVING COUNT(*) > 1 ) ORDER BY fieldlist 或 SELECT * FROM table WHERE key IN ; ( SELECT key FROM table GROUP BY key ; HAVING count(*) > 1) ORDER BY fieldlist
【发表评论】
|
|||||||