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 to display all the duplicate records from the oracle
Table?

Answer Posted / nagam

select count(*),empno from emp group by empno having count(*)>1;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of containers?

1165


what is 'reconsideration error' and how can i respond to this error and how to debug this

2573


If you want to use a same piece of code in different jobs, how will you achieve this?

1242


What is apt_config in datastage?

1099


What are the components of ascential data stage?

1136


How to clean the datastage repository?

1084


What are routines in datastage? Enlist various types of routines.

1061


Lookup constraints

1217


What are the stages in datastage?

1053


Explain the situation where you have applied SCD in your project?

2000


What are the types of hashed files in data stage

1075


Define orabulk and bcp stages?

1090


root tree will find which is server job and which is parallel job?

1901


What are the features of datastage flow designer?

1009


Can you explain players in datastage?

1167