var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete Duplicate Rows
I have the following query to select duplicate rows from the table. How can i delete them with out using temp table.
select UserName, Title, Name, ColWidth, Sequence
from table1 (nolock))
Group by UserName, Title, Name, ColWidth, Sequence
Having count(*) >1
Any help would be greately appreciated.
Why don't you want to use a temp table?
The easiest (don't know about fastest) way for med would be:
1. Select DISTINCT into a temp table
2. Truncate the original
3. Select all the rows back.
Interesting problem, if this can be done in one query.. It would be of use for me too.
i posted a similar qn to the forum some time back. pl check the link below
btw, if you find any other gud solutions, pl let me know