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

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3945


Explain about relational database management systems?

914


Who are naive users?

948


Why does this query return 0?

967


What is normalization? Explain different levels of normalization?

62697


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

947


What is dbms explain in brief?

954


What is an application role and explain a scenario when you would use one?

949


Explain about the relational database?

994


What is a database development?

901


How to customize error conditions.

2096


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

2100


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

918


Explain about normal forms?

985


Explain about relational operator join?

978