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

Does sql*plus also have a pl/sql engine?

1079


how to include character strings in sql statements? : Sql dba

1071


Why do we need a foreign key?

1093


What is localdb mssqllocaldb?

1066


The select into statement is most often used to create backup copies of tables or for archiving records?

1064


Can we use insert statement in function?

999


What is the usage of sql functions?

1144


write an sql query to find names of employee start with 'a'? : Sql dba

1027


What is a sql instance vs database?

1113


What will you get by the cursor attribute sql%rowcount?

1036


What do you think about pl/sql?

1029


What is difference between joins and union?

1124


what are all the different types of indexes? : Sql dba

1046


How many rows can sqlite handle?

1110


How is pl sql different from sql?

1086