Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

how will I find the duplicate rows count from employees
tablein oracle.

Question Posted / gettosrinivas

Answers were Sorted based on User's Feedback



how will I find the duplicate rows count from employees tablein oracle...

Answer / manoj

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

Is This Answer Correct ?    18 Yes 0 No

how will I find the duplicate rows count from employees tablein oracle...

Answer / avik ganguly

select * from emp a where rowid = (select max(rowid) from
emp where empno = a.empno group by empno having count(*) >1)

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB Development Interview Questions

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

Write the difference between case version and decode version.

2 Answers  

Explain about normal forms?

0 Answers  

What is denormalization and when would you go for it?

9 Answers   NBP,

What is the physical representation for a many-to-many relationship?

0 Answers  

Explain what a database is?

0 Answers  

How to create an external table.

1 Answers  

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

How to customize error conditions.

0 Answers  

How to combine two function together?

0 Answers  

What is the maximum length of an extended property?

0 Answers  

Explain about relational database management systems?

0 Answers  

For more DB Development Interview Questions Click Here
Categories