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
How should testing be conducted?
What is coverage measurement?
What is recovery/error testing?
What is emulator?
What is the difference between debugging and testing?
plz give me any body some 3top UAT test cases, Advance thanks?
Explain test procedure?
Explain test plan?
How to test documents in a project that span across the software development lifecycle?
What is eexception?
What is user documentation?
What it means by test harness?
What is a database administrator?
What is differences between SCS-1,2 and 3
When is it ideal that the testing is stopped?