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

For the 7 stages of the SDLC (Planning, Analysis, Design, Development, Testing, Implementation, and Maintenance), What are the major inputs and outputs of each stage? What are the primary activities in each stage? Who are the primary "players" involved in each stage (e.g., Tech Arch's BA's, Testers etc.)?

901


What is cause-effect graphing?

1039


what are Link Speed available for FCOE SAN?

1971


What is JBOD?

2011


Which is the current formal world-wide recognized documentation standard?

1504


Explain what n+1 testing is?

1161


What is the term for decomposing a software program so that latent design information can be extracted? 1. Reengineering 2. Regression 3. Restructuring 4. Reusability 5. Reverse engineering

2224


What is functional system testing?

1122


Explain monkey testing?

1023


What Testing process U r following in ur organization?

2379


What is called the process starting with the terminal modules?

1111


When should 'regression testing' be performed?

1083


What is future of FC SAN vs FCOE SAN

2110


What is the difference between the white box, black box, and gray box testing?

1031


What is structural testing?

1167