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 / seshu
SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
When sql appeared?
How many sql statements are used? Define them.
what is a unique key ? : Sql dba
Does db2 use sql?
What is the difference between rename and alias?
Explain spool.
Which table is left in join?
What is the usage of distinct keyword?
how to use case expression? : Sql dba
What is an implicit commit?
does sql support programming? : Sql dba
Can two tables have same primary key?
Explain two easy sql optimizations.
What are the three pl sql block types?
what is a database? : Sql dba