How to delete the duplicate records from table(having bulk
records)?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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
What is .net mobile input validation. : Microsoft dot net mobile
What are public and private assemblies ?
What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile
Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?
What is CLR,MSIL and Jit Compiler and their roll in .net
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
What is msil, and why should my developers need an appreciation of it if at all?
Explain the difference between l1 and l2 cache? : Dot net architecture
what is the shortcutkey for solution explorer and add new item?
How will you do windows authentication and what is the namespace?
What are library functions?