How to delete the duplicate records from table(having bulk
records)?
- 4 Answers
- 6760 Views
- BV, iGate, I also Faced
- E-Mail Answers
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 private constructor? And it's use?
What exactly is being serialized when you perform serialization? scope in C# ?
while developing a asp.net 2.0 ajax application how to maitain and check the ACID property for each transaction
Define a virtual memory? : Dot net architecture
hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays
Does application frame need host?
What is .net mobile lists. Explain with an example? : Microsoft dot net mobile
What are the different pipelining hazards and how are they eliminated? : Dot net architecture
what is inheritancy where u required ?
What is the difference between an application and a program?
what are clr,cls,cts?what is .net framework?
what is the need of vss to developer?
Dot Net Framework 
