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 / 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 is Recovery Scenario

1057


What is vdd - version description document?

1026


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

992


What is test documentation?

1041


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

2285


Describe your ideal working environment.

2801


What is quality assurance (qa)?

1080


What are the ways of functional testing? Can you give me an example of how to perform Functional testing on a Login Page for example.

1909


What is an equivalence partition (also known as an equivalence class)?

1132


What is a user manual?

970


how to use bugzilla plz tell me details processs

2004


how to download fullversion of JIRA(defect reporting s/w) s/w for free.can any provide web site for full version free download.

2494


Explain inspection?

899


What is incremental analysis?

1020


repeated testing of an already tested program, after modification, to discover any defects introduced or uncovered as a result of the changes in the software being tested or in another related or unrelated software component:

995