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


Please Help Members By Posting Answers For Below Questions

What is integration testing in software testing?

822


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?

882


What is difference between Agile and V model? Explain

2063


Explain interface?

785


What is static analyzer?

831


What is random/monkey testing?

846


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

1748


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

1766


what is the main purpose of informal review

1138


what are all the folders maintained in memory location?

1950


What is outputs?

766


Testing activity which is performed to expose defects in the interfaces and in the interaction between integrated components is?

874


Explain black-box testing?

781


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

2426


What is a user friendly document?

822