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
What are expressions?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are procedures used for?
Can we delete column in sql?
What is the purpose of primary key?
Is sql a programming?
What are commit, rollback, and savepoint?
what is schema? : Sql dba
What is the sql case statement?
What are different joins used in sql?
What is indexing oracle sql?
Why do we use procedures in pl sql?
How do you declare a user-defined exception?
does sql support programming? : Sql dba
Can we insert in sql function?