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
- 50828 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
what is data manipulation language? : Sql dba
how do you control the max size of a heap table? : Sql dba
What is memory optimized table?
What is the difference between delete and truncate statement in sql?
Does asenumerable execute the query?
What is a recursive stored procedure?
What is sql constant?
Which command is used to call a stored procedure?
What is the most important ddl statements in sql are?
What is the difference between python and sql?
What is view? Can we update view
What is the use of procedures?
What is group by in sql?
What is update query?
How many unique keys can a table have?
