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
IN integration testing tester should knowledge of code or not?
What are the emerging trends in the testing and QA arena?
What is test incident report?
What are the different types of QA Testing approaches and the process of each?
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?
What do enterprises do for QC 11 to prevent minimum data loss ?
What is fuzz testing and when it is used?
What the basic components of defect report format are?
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?
What does cots represent?
How you would allocate a task to team members?
How will you log a Defect when you are in the process of executing a test case?
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
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
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