How to find out duplicate records in a table(Query)
Answer Posted / santosh
we have to use the group by with having command to get the duplicate values. this query shall show the result of only the users have duplicate values in the employee table.
Syntex:
Select columnName From Table_name
Group By columnName
Having count (*) > 1
Example:
SELECT UserID FROM employee
GROUP BY userid
HAVING count( * ) > 1
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Mention what are the categories of defects?
Explain functional testing?
how cam www sites be tested
What is ieee - institute of electrical and electronics engineers?
What are the experience-based testing techniques?
What is branch coverage?
viewing entire results after the batch run in qtp Is there is a easier way view the complete results with out opening one by one test scripts
What is user documentation?
How u r managing the staff unavailability?
What do you mean by automated testing?
Testing activity which is performed to expose defects in the interfaces and in the interaction between integrated components is?
What is the maximum length of cable supported in SCS-1,2 and 3?
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie
What studies data flow analysis?
What is difference between known regression testing and unknown regression testing?