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?
Answers were Sorted based on User's Feedback
Answer / satheesh
SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID)
FROM EDUCATION E2 WHERE E1.EMPID=E2.EMPID)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sirisha
select id,count(id) from Education group by id having count(id)>1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / aditi yadav
SELECT *FROM Employee
WHERE JoiningDate >= DATEADD(M, -2, GETDATE())
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / karthik
i think ths will work!
select * from table_name where rowid in (select max
(rowid) from table_name groupby duplicate_field_name);
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / lavanya
SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>
Is This Answer Correct ? | 10 Yes | 14 No |
Answer / dawood
SELECT COUNT(EMPNO),ENAME FROM EDUCTION
GROUP BY ENAME;
Is This Answer Correct ? | 5 Yes | 10 No |
Answer / harish
select * from education where rownum < ( select max(rownum)
from education group by <column_name> )
Is This Answer Correct ? | 15 Yes | 24 No |
What is oracle sql called?
What does bitemporal mean?
what is self join and how it works??
Can we insert data in view?
What is window clause?
Define join and name different types of joins?
explain mysql aggregate functions. : Sql dba
What is dense_rank in sql?
What is scalar function in sql?
What is the maximum rows in csv?
What is a nested table in word?
What are functions in sql?