Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out duplicate records in a table(Query)
- 6 Answers
- 13276 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
How the 2 wings and body of the butterfly model of test development is represented?
What is oo integration testing?
what is automation testing process? What are the main steps invloved in it?
Which is the best institute in chennai to learn Softyware testing? Please help.
Explain exhaustive testing?
What is ansi - american national standards institute?
HOW TO PERFORM DATABASE TESTING
What is Functional, Non-Functional, and Regression used for (i.e. the purpose of each)?
what is the difference between software testing and quality testing? how do they vary,waht is the process of testing in both software and quality?
What is intrusive testing?
What is the role of moderator in the review process?
how cam www sites be tested
A type of functional testing, which investigates the functions relating to the detection of threats, such as virus from malicious outsiders?
what is the diff or relation between qa and verification qc and validation
Explain the difference between functional and structural testing.
