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 retrieve only duplicate values in a table

Answer Posted / siva

Select* from emp where rowid not in(select max(rowid) from emp group by empno);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why stored procedures are faster than query?

1039


What are the built in functions of sql?

1042


Can we call a function containing dml statements in a select query?

989


What is trigger explain it?

1022


How many indexes can be created on a table in sql?

1066


What is the purpose of primary key?

1042


What are all ddl commands?

1093


What is trigger and how to use it in sql?

1030


What jobs use sql?

988


What are the different types of joins in sql?

1820


What is a clob in sql?

1031


What is a heap in sql?

1079


What is a primary key example?

970


what is a database transaction? : Sql dba

1194


What is the starting oracle error number? What is meant by forward declaration in functions?

1007