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?
- 28 Answers
- 47192 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 sorting in sql?
What does over partition by mean in sql?
how can we know the count/number of elements of an array? : Sql dba
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is an example of translating a date into julian format?
What are different functions in sql?
How do you create a db file?
What is an index in sql with example?
What are the three pl sql block types?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Which operator is used in query for pattern matching?
What is difference between pls_integer and integer?
How do I partition a table in sql?
Why select is used in sql?
What is difference between my sql and sql?
