07 October 2009

Query to get duplicate records

select count(*) as num, a, b from a group by b,a having count(*) > 1

No comments:

Post a Comment