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 / deepika galankar

if table " stud " contains data :
studid name
1 xyz
2 pqr
3 per
1 xyz

then query is

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

thank u .

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the stlc (software testing life cycle) and sdlc (software development life cycle)?

1083


We use the output of the requirement analysis, the requirement specification as the input for writing …

1330


'This life cycle model is driven by schedule and budget risks' this statement is best suited for.

1072


Explain metric?

1072


Explain incremental integration testing?

1121


What is closed box testing?

1147


What is test/qa team lead?

1068


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:

1051


please suggest me some topics for research in software testing/software reliability......

1960


Explain 3 high priority test cases for the performance of MSN search engine.

1147


What studies data flow analysis?

1213


The purpose of which is to allow specific tests to be carried out on a system or network that resembles as closely as possible the environment where the item under test will be used upon release?

1135


Hello Frds, Iam Going to attend Face to face interview on coming Monday in Wipro. Iam going with 3+ years of experience.I'm requesting u all of Frds who attended wipro recently pls post your interview experience, the questions they asked so that it will be help ful to me and other frds who are going to attend wipro.. thanks in advance

3076


How to write an implementation plan for our QA system with small budget, from scratch.

2118


What is the key difference between preventative and reactive approaches to testing?

1082