Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / madhav

select name,count(name) from mastertable group by name
having count(name)>1

instead of NAME use your own fields


Best of luck

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What the basic components of defect report format are?

966


What is random/monkey testing? When is it used?

1065


What is your daily routine in your office?

2728


I need to learn everything I can about Function, Non-Functional and Regression Testing. What is the best online resource?

1225


What can be thought of as being based on the project plan, but with greater amounts of detail?

1055


What is top-down approach?

1172


What is technical review?

1015


What is the average size of executables that you have created?

1347


What is the common risk that leads to project failure?

1120


Which one of the following activities is the most efficient and most cost effective at identifying defects? 1. Prototyping 2. Unit test 3. Beta test 4. Design/code inspection 5. Risk analysis

2080


What is the difference between web application and desktop application in the scenario of testing?

1081


What is bottom-up testing?

1091


What is memory leaks and buffer overflows ?

1114


What is difference between Agile and V model? Explain

2303


IN integration testing tester should knowledge of code or not?

2106