Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the duplicate rows from a table in SQL Server ??
- 3 Answers
- 7298 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudha511
select distinct * into #temp from sampletbl
delete sampletbl
insert into sampletbl
select * from #temp
drop table #temp
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do you want to join software field as you have done your BE in Electronics?
What is the maximum size of a row in sql server?
What is difference between group by and having?
What is the cartesian product of the table?
What does the on delete cascade option do?
What are the new features are introduced in sql server 2012 reporting services?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is the bookmark lookup and rid lookup?
Explain stored procedure?
Can you leave a union at any time?
How to create a dynamic cursor with the dynamic option?
Does the order of columns in update statements matter?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to check table values in sql server?
