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
What is integration testing in software testing?
Example: A Bank teller determines a need for a new software that displays customer information on her screen. What would using a Waterfall Methodology look like AND what would an Agile Methodology look like in creating this software product?
What is difference between Agile and V model? Explain
Explain interface?
What is static analyzer?
What is random/monkey testing?
HI to all this is dinakar i am planning to write istqb foundation level exam but i dont have the material so any one have material regards that one please send to my id was dinakarmails@gmail.com thanks alot in advance
hello everybody, I have started learning testing tools and have familiarity with winrunner and general testing knowledge.Pl let me know what other stuff should i learn. I had 6 yrs of exp in GIS field and now i want to shift to testing tools. I left my job in 2001 now i want to enter into the market again. Could any of u help me how to approach the market. Any suggetions are very helpful to me. I am in US though. Thanks in advance
what is the main purpose of informal review
what are all the folders maintained in memory location?
What is outputs?
Testing activity which is performed to expose defects in the interfaces and in the interaction between integrated components is?
Explain black-box testing?
Hey friends...mail me interview questions of manual testing.. Give me explanation of Automated Tools quality center on my gmail mca.rachna21@gmail.com quick test profession load runner
What is a user friendly document?