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?
Answer Posted / 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 |
Post New Answer View All Answers
How do I save the results of sql query in a file?
How to know the last executed procedure?
What are string functions in sql?
What is structural independence and why is it important?
What is sql in java?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How do you declare a user-defined exception?
Which is better join or subquery?
How to revise and re-run the last sql command?
what are the security recommendations while using mysql? : Sql dba
What is primary key secondary key alternate key candidate key?
What is the sql query to display the current date?
What are the different types of joins in sql?
What is the unique index?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba