SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY RNO,NAME having

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

29 Answers
52615 Views
Alps, Aricent, Bank Of America, Wipro, I also Faced
E-Mail Answers

Answer Posted / seshu

SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;

Is This Answer Correct ?

7 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to get a list of columns in an existing table? : Sql dba

1011

What is an intersect?

1156

Does asenumerable execute the query?

1097

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4461

what is blob? : Sql dba

1220

Will truncate release space?

989

What is cte?

1021

What are data types in pl sql?

1197

What is primary key in db?

1070

Which one is better subquery or joins?

1114

How do I restart sql?

1026

What is the sql query to display the current date?

1093

What are the different types of dbmss?

1054

What is substitution variable?

1098

How do I kill a query in postgresql?

1188