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 / kumargvk
select * from education a where rownum>(select max(rownum)
from education b where b.rno=b.rno)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does index help in query performance?
Is microsoft sql free?
Show the cursor attributes of pl/sql.
Why do we need pl sql?
Why indexing is needed?
What is a natural join sql?
Explain about various levels of constraint.
Define the select into statement.
What are the properties of a transaction?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is count * in sql?
What is a crud api?
How can I get the number of records affected by a stored procedure?
does sql support programming? : Sql dba
How would you convert date into julian date format?