Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out duplicate records in a table(Query)
- 6 Answers
- 13471 Views
- CybAge, I also Faced
- E-Mail Answers
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
What is functional specification?
What is total quality management?
How many effort estimation methods available in market for testing?
What is qa engineer?
What is test management review and why it is important?
Hi All!!Can anyone please suggest some better website to learn Mainframe Testing??Am very much new to Mainframes. Thanks in Advance Nithya
Explain a good test engineer?
What are the different methodologies in agile development model?
what are the different types of questions in testing from related to projects, plz help me in quickly
Your audit indicates that the corporate quality management system did NOT work as it should have. How should this finding be categorized? 1. Minor nonconformance 2. Major nonconformance 3. Deficiency 4. Observation 5. Catastrophic failure
What is the difference between uat (user acceptance testing) and system testing?
what is automation testing process? What are the main steps invloved in it?
What is fuzz testing and when it is used?
what are all the documents needs to be submitted as a part of test closure?
Explain in a testing project what testing activities would you automate?
