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
Mention what the purpose behind doing end-to-end testing is?
What it means by test harness?
Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie
How can you eliminate the product risk in your project?
Which technique can be used to achieve input and output coverage? It can be applied to human input, input via interfaces to a system, or interface parameters in integration testing.
What is peer reviews?
What do you mean by trend analysis?
What is incremental analysis?
Explain what the difference between latent and masked defects is?
hello everybody, I have started learning testing tools and have familiarity with winrunner and general testing knowledge.Pl let me know what other stuff should i learn. I had 6 yrs of exp in GIS field and now i want to shift to testing tools. I left my job in 2001 now i want to enter into the market again. Could any of u help me how to approach the market. Any suggetions are very helpful to me. I am in US though. Thanks in advance
What is disaster recovery testing?
What are the check points we need to consider while performing Database migration (ex: from oracle 8i to 9i)
How to improve in english
Set a=description.Create a("name").value="Google" Set b=description.Create b("Title").value="Google" Set c=description.Create c("micclass").value=" webedit" 'c("name").value="q" 'c("type").value="text" 'Set d=description.Create 'd("name").value="q" Set e=description.Create e("micclass").value="webbutton" e("name").value="Google Search" Set h=description.Create h("name").value="qtp - Google Search" Set desc=description.Create desc("micclass").value="webelement" desc("type")="qtp" Set l=description.Create l("title").value="qtp - Google Search" 'invokeapplication"C:\Program Files\Internet Explorer\IEXPLORE.EXE","http://www.google.co.in/" invokeapplication"C:\Program Files\Internet Explorer\IEXPLORE.EXE" Browser(a).Page(b).WebEdit(c).set"qtp" Browser(a).Page(b).WebButton(e).click set z=Browser(h).Page(l).childobjects(desc) i=z.count print i 'For j=0 to i -1 ' m=z(j).getroproperty("text") ' msgbox m ' print m ' 'Next hi guys this is anil. i am beginner in advance qtp. i am trying to write script for searching web element (QTP)in google. i have posted a script plz check it. send me solution how to write scripting for search and counted no qtp word in google search . plz tell me the solution ASAP
What is the difference between test scenarios and test strategy?