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 difference between SCSI-2 and SCSI-3 Standard?

1869


Functional testing?

957


how many types of automation frame works are there?

1114


What is v- diagram (model)?

1004


IN integration testing tester should knowledge of code or not?

2065


What is test specification?

1003


What is test schedule?

1186


What is the maximum length of cable supported in SCS-1,2 and 3?

1743


have u write any sanity testcases?

2093


Explain inputs?

943


What is software bug?

1118


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

924


During the testing of a module tester, 'x' found a bug and assigned it to a developer. But developer rejects the same, saying that it's not a bug. What 'x' should do?

1201


Can anyone provide the definitions for the following abbreviations? Thanx to anyone who could CIT CAP

2055


Mention what are the categories of defects?

980