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

Explain debugging?

920


I am having 1.5 years of exp. in Manual testing.What I have to do now? Should I do ISTQB Certification or Perl/Shell Scripting Languages? OR Anything else.Please Guide me properly.

3037


What is boundary value testing?

1045


What's Stress Testing?

1112


How many test cases will be there for testing the numbers of range -10.0 to 10.0? How it is classifying?

2042


Explain branch testing?

1004


How would you test the login feature of a web application?

1111


Explain storage testing?

1042


What are the different types of QA Testing approaches and the process of each?

1027


What is recovery/error testing?

1019


How do you obtain the expected results for testing a search operation?

924


Mention what the difference between pilot and beta testing is?

968


1). explain need of software testing? 2). explain difference between developer testing & test engineers testing? 3). explain difference between verification & validation 4). which process your organization follows to develop an application? 5). explain v-model? & what is the meeting point in v-model?

2661


What are the categories of defects?

1013


What are the emerging trends in the testing and QA arena?

2285