There are scenarios where you need to remove duplicates and you need to get only duplicates. Below examples ideally good for your project purpose.

SQL Query: How to remove duplicates:

SELECT DISTINCT(Column_name) 
from test_table;

The above query selects all distinct values.

SQL Query: How to get only duplicate values (or) You Can Use This Query to Verify Duplicates Exists

SELECT COL1, COL2,COL3,COUNT(*)  
FROM TEST_TABLE
WHERE PAN_ID >=10
GROUP BY COL1, COL2, COL3
HAVING COUNT(*) > 1;

Related Posts