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
- 52630 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohan
select count(*),column_name from table_name group by
column_name having count(*)>1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are secondary keys?
How much does sql cost?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Is like operator in sql case sensitive?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
Why self join is used in sql?
Compare sql & pl/sql
How many joins can you have in sql?
Why we use triggers in mysql?
What is the difference between having and a where in sql?
What is cte sql?
How do I tune a sql query?
How do I add a database to sql?
What do you understand by pl/sql cursors?
Does db2 use sql?
