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

IN integration testing tester should knowledge of code or not?

2055


What are the emerging trends in the testing and QA arena?

2271


What is test incident report?

937


What are the different types of QA Testing approaches and the process of each?

1011


Testing an SAP B1 -Add -on ? How?Different types of testing done, functional areas to be tested, any check list for testing SAP B1 as SAP takes care of Date fields, validation of text fields, telephone fields etc.... ?What to be tested and how?

2154


What do enterprises do for QC 11 to prevent minimum data loss ?

2207


What is fuzz testing and when it is used?

976


What the basic components of defect report format are?

930


I need to learn everything I can about the different types of Test Activities (i.e., Test Strategy, Test Plan, Test Cases, etc.). What is the best online resource?

1074


What does cots represent?

954


How you would allocate a task to team members?

1053


How will you log a Defect when you are in the process of executing a test case?

2122


I. Requirements are formally reviewed. II. Requirements are formally approved. III. Requirements are placed under configuration control. IV. Requirements are implemented in code. Using the above statements, when are requirements considered baselined? 1. I and II 2. I, II, and III 3. I, II, III, and IV 4. I only 5. I, III, and IV

2298


I would like to know the kinds of questions that could come up with regard to backend testing? As i am new to this field would also know if backend testing is restricted only to sql and unix. If at all anyone has any information on the same kindly get back to me..thanks

2200


I am planning to write a ISTQB Certification exam , i don't know about EXAM fee structures , please tell me the fee structure ? mail id: karthitkd.123@gmail.com

1914