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 are all the folders maintained in memory location?

2219


What n+1 testing is?

1092


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

2127


Which review is normally used to evaluate a product to determine its suitability for the intended use and to identify discrepancies?

1248


Explain what lcsaj is?

1108


Explain ad hoc testing?

1136


Mention what the meaning of breath testing is?

1166


Metrics of your Project?

2220


What is user documentation?

1075


A type of functional testing, which investigates the functions relating to the detection of threats, such as virus from malicious outsiders?

1306


When is rtm (requirement traceability matrix) prepared?

1147


What is random/monkey testing?

1153


What is web application testing

2306


What is the most critical component in SAN?

5115


There is very little time to test due to the development team delay how will you handle this situation?

2220