How to delete the duplicate records from table(having bulk
records)?
- 4 Answers
- 6713 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 |
Let's say I have an existing application written using Visual Studio 6 (VB 6, InterDev 6) and this application utilizes Windows 2000 COM+ transaction services. How would you approach migrating this application to .NET ?
what is the shortcut key for toolbox and add existing item?
What is a service class?
Please tell me the .net 2.5 frame work with example
How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts
can aspx page have multi language declarations ?
What are the types of application software?
what is Difference beetween Array and Hash Table.?
How to upload in video,mp4,in .net 4.5 ..?
Explain pipelining? : .NET Architecture
Explain dotnet framework ?
Difference between throw exception and rethrowing ?
Dot Net Framework 
