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 are all the folders maintained in memory location?
What n+1 testing is?
Which one of the following activities is the most efficient and most cost effective at identifying defects? 1. Prototyping 2. Unit test 3. Beta test 4. Design/code inspection 5. Risk analysis
Which review is normally used to evaluate a product to determine its suitability for the intended use and to identify discrepancies?
Explain what lcsaj is?
Explain ad hoc testing?
Mention what the meaning of breath testing is?
Metrics of your Project?
What is user documentation?
A type of functional testing, which investigates the functions relating to the detection of threats, such as virus from malicious outsiders?
When is rtm (requirement traceability matrix) prepared?
What is random/monkey testing?
What is web application testing
What is the most critical component in SAN?
There is very little time to test due to the development team delay how will you handle this situation?