DB Development Question:
Download Questions PDF

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

Answer:

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

Download DB Development Interview Questions And Answers PDF

Previous QuestionNext Question
What is the family trees and connection by clause?In which phase of mload can i use .FILLER?