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
- 51634 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / jay k patel
SQL> select * from emp;
ENO ENAME DOJ DESGN ADDRESS BSAL
---------- ------- --------- ------- ------- ----------
1 jay 04-JAN-80 md vapi 50000
2 vijay 04-FEB-75 manager vapi 7000
1 ajay 12-JAN-77 dba vapi 9000
3 rajay 05-MAR-70 cleark vapi 5000
4 sujay 28-JAN-73 dba vapi 6000
5 jayesh 07-APR-74 cleark vapi 8000
7 jaymin 04-JAN-62 analyst vapi 4000
6 jaynis 10-MAY-69 dba vapi 9000
1 jayur 04-JAN-74 manager vapi 4000
12 jaynil 14-DEC-71 cleark vapi 2000
10 rows selected.
SQL> SELECT desgn , count(*)
2 FROM emp
3 GROUP BY Desgn
4 Having count(*) > 1 ;
DESGN COUNT(*)
------- ----------
cleark 3
dba 3
manager 2
SQL>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is indexing in sql and its types?
What are the topics in pl sql?
Explain alias in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is out parameter used for eventhough return statement can also be used in pl/sql?
Can I create table without primary key?
How do you drop a trigger?
How to look at the current sql*plus system settings?
What is Materialized View? In What Scenario we Use Materialized View?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Can %notfound return null after a fetch?
What does the acronym acid stand for in database management?
What is sql used for?
What are different types of tables in sql?
What are the advantages of indexing?
