Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out duplicate records in a table(Query)
- 6 Answers
- 13307 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 eexception?
What is the bottom-up approach?
What is compliance testing ?
What the difference between latent and masked defects is?
Explain compatibility testing?
How much testing is enough?
Which is the current formal world-wide recognized documentation standard?
What is parameter?
What is impact analysis? As a tester how will you do impact analysis in your project?
i want learn "itesting tool"....which is best institutes to learn "itesting tool" in hyderabad or banglore ?plz give me reply as soon as posible?
What is what are the parameters of performance testing?
What does the mclabe cyclomatic complexity of a program determine?
what are all the documents needs to be submitted as a part of test closure?
plz give me anybody test data expected result during prime number programe ? advance thanks
What is data flow analysis?
