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
- 51121 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sarath
I don't know the exact intention of the above answers, but I am making mine clear that to find the TOTAL DUPLICATED RECORDS and THEIR COUNT OF REPETITIONS, the Pseudo code is:
Select col1,col2,col3,....,COLn count(*) from <TN>
group by col1,col2,col3,....,COLn having count(*) > 1;
Wish everybody complies with it, its tested.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to use distinct and count in sql query? Explain
What is a full join?
What are the popular database management systems in the it industry?
what is msql? : Sql dba
What are field types?
How many types of triggers are there in pl sql?
What is the difference between the sql*loader and import utilities? : aql loader
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is mutating trigger?
Which data dictionary views have the information on the triggers that are available in the database?
Does a user_objects view have an entry for a trigger?
what are the security recommendations while using mysql? : Sql dba
How do I audit the sql sent to the server?
What is difference between procedure and trigger?
explain the options of myisamchk to improve the performance of a table. : Sql dba
