Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Mention what the purpose behind doing end-to-end testing is?

1207


What it means by test harness?

1107


Please some one answer these Q's 1.Modules in Pension Domains ? 2.What Should we Test on Pension Domain.? Thanks in Advance Stewie

3147


How can you eliminate the product risk in your project?

1252


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.

1511


What is peer reviews?

1175


What do you mean by trend analysis?

1172


What is incremental analysis?

1119


Explain what the difference between latent and masked defects is?

1106


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

2039


What is disaster recovery testing?

1068


What are the check points we need to consider while performing Database migration (ex: from oracle 8i to 9i)

2269


How to improve in english

1793


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

3123


What is the difference between test scenarios and test strategy?

1127