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

How should testing be conducted?

1097


What is coverage measurement?

1201


What is recovery/error testing?

1068


What is emulator?

1185


What is the difference between debugging and testing?

1159


plz give me any body some 3top UAT test cases, Advance thanks?

2143


Explain test procedure?

1047


Explain test plan?

1075


How to test documents in a project that span across the software development lifecycle?

1119


What is eexception?

1101


What is user documentation?

1015


What it means by test harness?

1054


What is a database administrator?

1014


What is differences between SCS-1,2 and 3

1841


When is it ideal that the testing is stopped?

1074