Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the duplicate records from table(having bulk
records)?
- 4 Answers
- 7454 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 |
Explain .net mobile automatic paging? : Microsoft dot net mobile
difference between Response.write,server.transfer and also which one is used when ?
Explain difference between state server and sqlserver? : .NET Architecture
What is a clickonce application?
Explain what does the term "green architecture" mean? : .NET Architecture
while developing a asp.net 2.0 ajax application how to maitain and check the ACID property for each transaction
How does an appdomain get created?
IS IT Possible to inherit the AJAX page from child class which(child) is inherit from page class.Because i should apply some security in child class
Can you Explain <mobile:link> element .net mobile with example? : Microsoft dot net mobile
When do I need to use gc.keepalive?
how to change the application name?
What is password attribute of the textbox control of .net mobile? : Microsoft dot net mobile
Dot Net Framework 
