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 delete the duplicate records from table(having bulk
records)?

Answers were Sorted based on User's Feedback



How to delete the duplicate records from table(having bulk records)?..

Answer / rajani

delete from emp where rowid not in ( select max(rowid) from emp group by empno )

Is This Answer Correct ?    6 Yes 1 No

How to delete the duplicate records from table(having bulk records)?..

Answer / asha

DELETE FROM school WHERE badgeid NOT IN(SELECT MAX
(badgeid) FROM school GROUP BY id);

Is This Answer Correct ?    5 Yes 4 No

How to delete the duplicate records from table(having bulk records)?..

Answer / venkat

delete from employee
where
empid in (select e.empid from employee e, employee e1
where e1.empid=e.empid
group by e.empid
having count(e.empid)>1)

Is This Answer Correct ?    2 Yes 2 No

How to delete the duplicate records from table(having bulk records)?..

Answer / mml

delete from students where badgeid not in (select max(id)
from students group by badgeid);

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Dot Net AllOther Interview Questions

9. Oop-Class A has m1 metthode Class B has m1 metthode and C is the calss that inharits A class, A class inharits B class. If Object dim c as new A() c.m1(), Tell me which mettode of class will call

2 Answers   PCS,


What is .net mobile input validation. : Microsoft dot net mobile

0 Answers  


What are public and private assemblies ?

0 Answers  


What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile

0 Answers  


Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?

0 Answers  


What is CLR,MSIL and Jit Compiler and their roll in .net

1 Answers   PCS,


HI THIS IS THIRUMAL. I AM COMPLETED MY MCA IN 2009 WITH 64%. NOW I AM LOOKING FOR A JOB(FRESHER)IN HYDERABAD.PLEASE IF YOU FIND ANY OPENINGS IN ANY COMPANY SEND IT TO MY MAIL ID PLEASE.. SKILL SET : C,C++,C#.NET,ASP.NET,ADO.NET,SQL SERVER, SSIS,SSRS EMAIL ID : THIRU104@GMAIL.COM THANKS & REGARDS D.THIRUMAL

1 Answers  


What is msil, and why should my developers need an appreciation of it if at all?

0 Answers  


Explain the difference between l1 and l2 cache? : Dot net architecture

0 Answers  


what is the shortcutkey for solution explorer and add new item?

5 Answers   Six Sigma,


How will you do windows authentication and what is the namespace?

0 Answers  


What are library functions?

0 Answers   DELL,


Categories