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 |
difference between data reader and dataset
Wcf- What is ABC
What does the term "green architecture" mean? : .NET Architecture
What is textbox control of .net mobile? : Microsoft dot net mobile
can aspx page have multi language declarations ?
What is a service class?
Explain domestic architecture artifacts? : .NET Architecture
hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays
what is web service?
which of the following statement is true about gac. a)it is being handled by .net framwork b)It is special folder c)it can have files with same name etc etc.
What is the use of CLR in .NET?
What's the difference between an application and a program?