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 the difference between the stlc (software testing life cycle) and sdlc (software development life cycle)?
We use the output of the requirement analysis, the requirement specification as the input for writing …
'This life cycle model is driven by schedule and budget risks' this statement is best suited for.
Explain metric?
Explain incremental integration testing?
What is closed box testing?
What is test/qa team lead?
repeated testing of an already tested program, after modification, to discover any defects introduced or uncovered as a result of the changes in the software being tested or in another related or unrelated software component:
please suggest me some topics for research in software testing/software reliability......
Explain 3 high priority test cases for the performance of MSN search engine.
What studies data flow analysis?
The purpose of which is to allow specific tests to be carried out on a system or network that resembles as closely as possible the environment where the item under test will be used upon release?
Hello Frds, Iam Going to attend Face to face interview on coming Monday in Wipro. Iam going with 3+ years of experience.I'm requesting u all of Frds who attended wipro recently pls post your interview experience, the questions they asked so that it will be help ful to me and other frds who are going to attend wipro.. thanks in advance
How to write an implementation plan for our QA system with small budget, from scratch.
What is the key difference between preventative and reactive approaches to testing?