posted 10 years ago
Hi Nagendra,
As per what i have understood,
Let x be the column you wanted to find duplicates on,
use group by clause on x then followed by having clause using the count function
For example: Select x from sometable group by x having count(x) > 1