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
- 52620 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / harish
select * from education where rownum < ( select max(rownum)
from education group by <column_name> )
| Is This Answer Correct ? | 15 Yes | 24 No |
Post New Answer View All Answers
Can there be 2 primary keys in a table?
What is benefit of creating memory optimized table?
Why do we need pl sql?
What is sql mysql pl sql oracle?
What is the left table in sql?
What are the various restrictions imposed on view in terms of dml?
How do you run a query?
What is sql stand for?
What is sqlerrm?
What are tables and fields?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is an invalid partition table?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What does the argument [or replace] do?
What are aggregate functions in sql?
