How to delete the duplicate records from table(having bulk
records)?
Answer Posted / mml
delete from students where badgeid not in (select max(id)
from students group by badgeid);
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Name some changes done since version 3.0?
What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile
What is cache coherency? : Dot net architecture
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.
I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....
Explain
Explain a .net mobile example with details? : Microsoft dot net mobile
what are constructors and destructors?
Explain 'managed' mean in the .NET context
Explain difference between machine config vs. Web config : Dot net architecture
Waht is Dot net Arcitecture
Explain about appdomains?
What are the types of application software?
what is polymorphism and advantage ?
Explain hard disk and what is its purpose? : .NET Architecture