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 |
what is the difference between Exportdll and Importdll ?
what is inheritancy where u required ?
What is difference between .net and visual studio?
how to minimize,maximize and restore my form programmatically?
1 Answers Interlac, Six Sigma,
how do you hide maximize,minimize and close box at the form title bar?
hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays
what is the difference between running an application with and without debugger?
Explain about validation?
Explain the Lapsed Listener problem in .net
Tell me .net mobile emulators? : Microsoft dot net mobile
What's the difference between an application and a program?
Hi, this is satish, i have more than 2 years of exp. on Microsoft .Net Technologies like C#, ASP.Net, VB.Net. But i am willing to change my platform into Testing tool. give me best suggestion for me.