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
For the 7 stages of the SDLC (Planning, Analysis, Design, Development, Testing, Implementation, and Maintenance), What are the major inputs and outputs of each stage? What are the primary activities in each stage? Who are the primary "players" involved in each stage (e.g., Tech Arch's BA's, Testers etc.)?
What is cause-effect graphing?
what are Link Speed available for FCOE SAN?
What is JBOD?
Which is the current formal world-wide recognized documentation standard?
Explain what n+1 testing is?
What is the term for decomposing a software program so that latent design information can be extracted? 1. Reengineering 2. Regression 3. Restructuring 4. Reusability 5. Reverse engineering
What is functional system testing?
Explain monkey testing?
What Testing process U r following in ur organization?
What is called the process starting with the terminal modules?
When should 'regression testing' be performed?
What is future of FC SAN vs FCOE SAN
What is the difference between the white box, black box, and gray box testing?
What is structural testing?