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?
- 29 Answers
- 51693 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
In the above query we have to add distinct before *. Else
duplicate rows will be fetched twice.
Thanks,
Lakshmi
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
define sql delete statement ? : Sql dba
What is latest version of sql?
What is audit logout in sql profiler?
Why do we use joins?
What are two statement types in sql?
What are pl/sql packages?
Which is the correct statement about truncate and delete?
What is recursive stored procedure?
What is difference between my sql and sql?
What are sql indexes?
what is online transaction processing (oltp)? : Sql dba
What is the usage of distinct keyword?
How does sql*loader handles newline characters in a record? : aql loader
What is the basic structure of an sql?
How many types of keys are there in sql?
