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

Is big data nosql?

949


Describe sql comments?

1044


Can we perform dml on view?

1044


What is an inconsistent dependency?

1046


Write a sql query to convert all character to uppercase after hypen.

1438


How is pl sql different from sql?

1093


Does access use sql?

1045


What is scalar function?

1054


what is the difference between where clause and having clause? : Sql dba

1000


how do you know if your mysql server is alive? : Sql dba

1078


What are stored procedures used for?

1003


What is a sql select statement?

1041


How do you modify a trigger?

928


List and explain the different types of join clauses supported in ansi-standard sql?

1356


What do we need to check in database testing?

1018