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 / vijay_1994

select count (column_name),column_name from table_name group by column_name having count(column_name)>1;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to get help information from the server? : Sql dba

987


how can we submit a form without a submit button? : Sql dba

1033


What are schema-level triggers?

1149


What are the events on which a database trigger can be based?

1237


what are integrity rules?

1090


How do you explain an index number?

1183


What is trigger with example?

1166


What is memory optimized table?

1086


What is the difference between the sql*loader and import utilities? : aql loader

1088


What is rank dense_rank and partition in sql?

1084


what is myisam? : Sql dba

1160


What is sql exception?

1012


Sql technical questions

1331


Explain raise_application_error.

1143


Where the sql database files are stored?

1072