Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the duplicate records in a table using sql
server
- 4 Answers
- 5448 Views
- I also Faced
- E-Mail Answers
Answer Posted / rakesh pattajoshi
delete from tbl where id not in(select max(id) from tbl group by name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the numeric attribute of the textbox control in .net mobile? : Microsoft dot net mobile
What is the difference between machine config vs. Web config : Dot net architecture
Explain the Lapsed Listener problem in .net
Explain cache memory? : Dot net architecture
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.....
What is application frame host?
What happens when you try to update data in a dataset in .net while the record is already deleted in sql server as backend?
What is an interrupt? : .NET Architecture
Define a virtual memory? : Dot net architecture
What is a virtual memory? : Dot net architecture
Explain about metadata?
Explain difference between machine config vs. Web config? : .NET Architecture
Explain about clr?
Explain about httpruntime.cach.get(); method?
What is a service contract, operation contract and data contract?
