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
- 50832 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / cesar di sanctis
select * from <table_name>
where <column_name> in
(select <column_name>
from <table_name>
group by <column_name>
having count(*) > 1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How can you load microsoft excel data into oracle? : aql loader
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is self-join and what is the requirement of self-join?
Does sql view stored data?
How do I view tables in mysql?
What is the current version of sql?
List and explain the different types of join clauses supported in ansi-standard sql?
Can we rollback after truncate?
What are the two different parts of the pl/sql packages?
What is the difference between instead of trigger and after trigger?
what is the difference between delete and truncate commands? : Sql dba
What is bind variable in pl sql?
What is interval partition?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
How many parts of a pl sql block are optional?
