Revisions to How to remove duplicates from table using SQL query

Post Merged (destination) from stackoverflow.com/questions/7680971/…

occurred Oct 9, 2011 at 1:37

added 6 characters in body

edited Oct 6, 2011 at 22:21

139.4k
22
223
293

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_IDNODE_EQ_NO) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_IDNODE_EQ_NO) as rn from yourtable ) select * from C where rn = 1

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) select * from C where rn = 1

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_EQ_NO) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_EQ_NO) as rn from yourtable ) select * from C where rn = 1

deleted 1 characters in body

Source Link

edited Oct 6, 2011 at 22:16

Mikael Eriksson

139.4k
22
223
293

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from @yourtableyourtable ) select * from C where rn = 1

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from @yourtable ) select * from C where rn = 1

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) select * from C where rn = 1

added 367 characters in body

Source Link

edited Oct 6, 2011 at 22:09

Mikael Eriksson

139.4k
22
223
293

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from @yourtable ) select * from C where rn = 1

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) delete C where rn > 1

This is not a query but a delete statement. It will delete/remove duplicate rows from your table

;with C as ( select row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from yourtable ) delete C where rn > 1

If you are only interested in querying the table and get the non duplicates as a result you should use this instead.

;with C as ( select *, row_number() over(partition by DUPLICATE_VAARS_DECISION order by NODE_ID) as rn from @yourtable ) select * from C where rn = 1

Source Link

answered Oct 6, 2011 at 22:02

Mikael Eriksson

139.4k
22
223
293

Loading

Collectives™ on Stack Overflow

Return to Answer