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
What is difference between SCSI-2 and SCSI-3 Standard?
Functional testing?
how many types of automation frame works are there?
What is v- diagram (model)?
IN integration testing tester should knowledge of code or not?
What is test specification?
What is test schedule?
What is the maximum length of cable supported in SCS-1,2 and 3?
have u write any sanity testcases?
Explain inputs?
What is software bug?
How do you obtain the expected results for testing a search operation?
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?
Can anyone provide the definitions for the following abbreviations? Thanx to anyone who could CIT CAP
Mention what are the categories of defects?