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...

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

Answer Posted / manoj

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

Is This Answer Correct ?    18 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

943


What is normalization? Explain different levels of normalization?

63000


What is the maximum length of an extended property?

968


In which table collections errors are stored.

2394


How to use timestamp datatypes

2014


Explain about post-relational databases?

997


How is data stored in dbms?

939


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.

2038


Who are end users in dbms?

962


How you can make a parameterized view?

994


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

1058


How to read and create .LDC data files which are used by linguatic dictionary.

2518


How would you design a database for an online site, which would average a million hits a day?

988


Explain about the database management systems.

955


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2146