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 Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?

Answer Posted / "d"

select count(*),ss from dd group by
ss having count(*)>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 do you respond to dementia behavior?

934


What is a sql schema used for?

1042


What does trigger mean in slang?

1013


How to Execute a Package in PL/SQL.?

1123


How do you clear the screen in sql?

1018


Is oracle and sql same?

958


What is the largest value that can be stored in a byte data field?

967


How do you sort in sql?

963


What is a nested table in word?

920


What mean sql?

956


How to pipe multiline string to isql?

969


what are numeric data types? : Sql dba

1008


what does the t-sql command ident_current does? : Transact sql

937


What do you mean by dbms? What are its different types?

959


What are the usages of sql?

1022