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 |
Explain about appdomains?
what is an assembly ?
i want to know that now a days which software course has demand and more opportunities please give me reply to my mail id
How can I write my own .NET host?
can u give me real example of how web.config overrides the machine.config file?
What is the purpose of hard disk? : Dot net architecture
2. I've a class Parent Class A and a Derived Class B. Here is a scenario. I've an instance of Class A as objA and an instance of Class B as objB. I can refer a child class variable as objB=objA, but cannot do objA=objB what is the reason?
Explain about developer benefit from memory management?
wild card character in sql ?
Explain pipelining? : Dot net architecture
Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile
What is WPF and WCF?