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
- 51633 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / a.balakrishna
select * from education where rowid in (select min(rowid)
from ex group by sno having count(*)>1);
100% it is true
Best of luck
9177509010
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why is stored procedure faster than query?
how to check server status with 'mysqladmin'? : Sql dba
What is a call statement? Explain with an example.
What is sql character function?
What is range partitioning?
What is recursive stored procedure?
What are the uses of sysdate and user keywords?
What are the different type of joins in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Is truncate ddl or dml?
Are null values same as that of zero or a blank space?
How do we accept inputs from user during runtime?
How many types of privileges are available in sql?
what are the different functions in sorting an array? : Sql dba
Explain commit, rollback and savepoint.
