Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out duplicate records in a table(Query)
- 6 Answers
- 13006 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 path analysis?
I am going for an interview for back end and ui testing. Can smone tell me some important questions?
What is ieee - institute of electrical and electronics engineers?
What is the objective of regression testing?
During the testing of a module tester, 'x' found a bug and assigned it to a developer. But developer rejects the same, saying that it's not a bug. What 'x' should do?
Testing wherein we subject the target of the test, to varying workloads to measure and evaluate the performance behaviors and the ability of the target and the test to continue to function properly under these different workloads?
In which phase should testing begin – requirements, planning, design, or coding?
Explain test bed?
What n+1 testing is?
What are the check points we need to consider while performing Database migration (ex: from oracle 8i to 9i)
What is a user guide?
please suggest me some topics for research in software testing/software reliability......
Hi do any one has dumps for ISTQB or ISEB exams for august or september exam 2013. Pleae mail qazwsx2631981@yahoo.co.in
In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), WHO are the stakeholders of each stage?
What is the difference between Manual Test Plan and the Automated Test Plan?
