Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?

Question Posted / seshu

Answers were Sorted based on User's Feedback



How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

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

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

Answer / sirisha

select id,count(id) from Education group by id having count(id)>1

Is This Answer Correct ?    0 Yes 0 No

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

Answer / aditi yadav

SELECT *FROM Employee
WHERE JoiningDate >= DATEADD(M, -2, GETDATE())

Is This Answer Correct ?    0 Yes 0 No

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

Answer / keerthana

select Student_Name,Dgree from Education
group by (Student_Name,Dgree) having count(*) > 1;

Is This Answer Correct ?    0 Yes 0 No

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

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

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

Answer / lavanya

SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>

Is This Answer Correct ?    10 Yes 14 No

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

Answer / guest

unionall

Is This Answer Correct ?    1 Yes 5 No

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

Answer / dawood

SELECT COUNT(EMPNO),ENAME FROM EDUCTION
GROUP BY ENAME;

Is This Answer Correct ?    5 Yes 10 No

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". ..

Answer / harish

select * from education where rownum < ( select max(rownum)
from education group by <column_name> )

Is This Answer Correct ?    15 Yes 24 No

Post New Answer

More SQL PLSQL Interview Questions

What is a ddl command?

0 Answers  

How is indexing done in search engines?

0 Answers  

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

Can we join two tables without common column?

0 Answers  

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

What does a pl/sql package consist of?

0 Answers  

What are three advantages to using sql?

0 Answers  

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

What is the use of index in sql?

0 Answers  

What is cursor in pl sql?

0 Answers  

how to create a primary key with out creating an index?

9 Answers   TCS,

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

For more SQL PLSQL Interview Questions Click Here
Categories