Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the duplicate records from table(having bulk
records)?
- 4 Answers
- 7285 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 |
Whate are resource files? How are they used in .net?
how to change the title of my window?
Explain about developer benefit from memory management?
what are the fundamental and common properties of .net controls?
What is MS chart control in visual studio?
I can't be bothered with cas. Can I turn it off?
What is the procedure on hardware that converts the ascii value to binary? : .NET Architecture
How do you handle this COM components developed in other programming languages in .NET?
0 Answers InfoAxon Technologies,
what are the events for a form?
Define an interrupt? : Dot net architecture
what is page_directive
What is the main Difference Between .Net 2003 and .Net 2005.and also Asp1.1,Asp2.0 and Asp3.0
Dot Net Framework 
