How to find out duplicate records in a table(Query)
Answer Posted / vishal
try this query
select name,count(*) from X1 (X1 being the table name)
group by name
having count(*)>1
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is top-down strategy?
Explain configuration management?
In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), WHO are the stakeholders of each stage?
tell some examples for driver and stub?
What is utilization?
Hi Guy's Pls. go to Forum of Allinterview.com for Testing Job Openings..You can find various job openings in Forum. You can submit ur resume too
How do you obtain the expected results for testing a search operation?
What is functional specification?
Explain system testing?
how to attach and detach databases in sql?
What is positive testing?
plz give me any body some 3top UAT test cases, Advance thanks?
What is RC update and BRIO?
Does anybody used Visio in QA.If so, can u please explain where and when u used visio diagrams
What are different types of protocols used in transportation and session layers of SAN?