Suppose the given table has 2 columns (id, phone_number):
SELECT id, COUNT(id)
FROM table_name
GROUP BY id
HAVING COUNT(id)>1
Learn Oracle Database from the Best Tutors
The best tutors for Oracle Database Classes are on UrbanPro
The best Tutors for Oracle Database Classes are on UrbanPro