How to find the duplicate rows count from employees table in oracle?

Submitted by: Administrator
select employee_id, count(*) from employees group by
employee_id having count(*) > 1
Submitted by: Administrator

Read Online DB Development Job Interview Questions And Answers