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
- 50750 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / lavanya
SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>
| Is This Answer Correct ? | 10 Yes | 14 No |
Post New Answer View All Answers
What is the non-clustered index in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is minus?
What is scope of pl sql developer in future?
What is sqlcontext?
Which kind of parameters cannot have a default value in pl sql?
Could you please provide oca (oracle 10g) dumps for my certification ?
How many parts of a pl sql block are optional?
What is compute?
What are the differences between in and exists clause?
How does a trigger work?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
How many scalar data types are supported in pl/sql?
how many tables will create when we create table, what are they? : Sql dba
Can one improve the performance of sql*loader? : aql loader
