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 / 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 |
Post New Answer View All Answers
What is memory optimized table?
What is the difference between pl and sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What are procedures used for?
How many types of primary keys are there?
What is procedure explain with program?
List the various privileges that a user can grant to another user?
When to use inner join and left join?
what are all different types of collation sensitivity? : Sql dba
Why are sql stored procedures used?
how would you get the current date in mysql? : Sql dba
What is the difference between rename and alias?
How do I start pl sql?
What does inner join mean?
Are pl sql variables case sensitive?