DB Development Question: Download DB Development PDF

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

Tweet Share WhatsApp

Answer:

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

Download DB Development PDF Read All 10 DB Development Questions
Previous QuestionNext Question
What is the family trees and connection by clause?In which phase of mload can i use .FILLER?