How to find out duplicate records in a table(Query)

Answer Posted / vishal

try this query

select name,count(*) from X1 (X1 being the table name)
group by name
having count(*)>1

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the major differences between stress testing, load testing, volume testing?

583


Testing methodology and when do you start testing activity?

1767


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?

1567


Explain code walkthrough?

617


Hi, Can any one please provide any links regarding the interview questions for Computer Systems Validation. I have got QA background and looking for a career in CSV in Pharmaceutical Companies. Thanks in advance...

1557






Usually how many members work in a project & how members are now working in a project. If there r difference between the above two questions why it is so?

1758


When should exploratory testing be performed?

611


What is error-based testing?

606


IN integration testing tester should knowledge of code or not?

1692


Explain mutation testing?

628


Explain interface?

573


What is a user guide?

597


What is control structure testing?

606


What is maintenance testing?

607


Test Items and Feature To Be Tested for calculator

1387