Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 29 Answers
- 50682 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
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
Define a temp table?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is sql performance tuning?
How is sql used in oracle?
Can we perform dml on view?
Write a query to find the names of users that begin with "um" in sql?
What is the difference between execution of triggers and stored procedures?
Explain the purpose of %type and %rowtype data types?
what is the use of friend function? : Sql dba
What does trigger mean in psychology?
How do you remove duplicates without using distinct in sql?
What is meant by truncate in sql?
Why is partition used in sql?
What are the different dcl commands in sql?
Can we join two tables without common column?
