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
- 51907 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmi narayana
select * from emp a ,
(select empno,count(*) from emp group by empno having count
(*) > 1) b
where a.empno = b.empno
| Is This Answer Correct ? | 27 Yes | 10 No |
Answer / kalaiselvan.j
select count(*),column_name from table_name group by
column_name having count(*)>1
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / smita
select a.empno, a.empname from education a,
(select empno, count(*) cnt from education group by empno
having count(*) > 1) b
where a.empno = b.empno
is the correct answer
| Is This Answer Correct ? | 12 Yes | 5 No |
Answer / 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 |
Answer / lakshmi
In the above query we have to add distinct before *. Else
duplicate rows will be fetched twice.
Thanks,
Lakshmi
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / seshu
SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / amit
select * from taruntest1 b where rowid not in (select min
(rowid) from taruntest1 a where a.a=b.a );
| Is This Answer Correct ? | 8 Yes | 5 No |
Answer / balaji
For Sample:
----------
select count(pmid) as Occurances,pmid from tablename group
by pmid having count(pmid)>1
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / rajesh kumar patnaik
SELECT ProductName
FROM Products
WHERE (ProductName IN
(SELECT ProductName
FROM Products
GROUP BY ProductName
HAVING COUNT(*) > 1))
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / aravind
select SPAN_UUID, SPAN_UNIT_UUID, count(*) from
SPAN_SPAN_UNIT group by SPAN_UUID, SPAN_UNIT_UUID having
count(*) > 1;
| Is This Answer Correct ? | 4 Yes | 2 No |
How can we overcome recursive triggers in SQL?
What is user in sql?
What are the types of keys?
what are set operators in sql? : Sql dba
What is the difference among union, minus and intersect?
Can there be more than one function with a similar name in a pl/sql block?
What is the difference between partition and index?
What is the difference between left join and right join?
What is the command used to fetch first 5 characters of the string?
What is sql clause?
What is sql*plus?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
