...e AS ( SELECT[foo], [bar], row_number() OVER(PARTITION BY foo, bar ORDER BY baz) AS [rn] FROM TABLE ) DELETE cte WHERE [rn] > 1 Play around with it and see what you get. (Edit: In an attempt to be helpful, someone edited the ORDER BY clause within the CTE. To be clear, you can order ...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...

...struction Number of rows and columns Sizing and position functions Reordering rows and columns Cell Editing and Validation Structures, defines and Messages Colours General cell information Operations Printing History Introduction After pushing the CList...