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 |
Define domestic architecture artifacts? : Dot net architecture
What is the difference between an event and a delegate?
Which software is used for .net programming?
3. Should validation (did the user enter a real date) occur server-side or client-side? Why?
i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?
Explain the race around condition? : .NET Architecture
What is .net mobile forms? : Microsoft dot net mobile
.net platform independent or dependent?
What are .net mobile controls features? : Microsoft dot net mobile
how can u manage sessions ?
What are the types of application software?
which control is used to compare two controls?