sql - How do I write a query to delete duplicates in a table? -

given table resembling one, called vehicleuser:

vehicleuserid | vehicleid | userid
1                     | 1001       | 2
2                     | 1001       | 2
3                     | 1001       | 2
4                     | 1001       | 3
5                     | 1001       | 3
6                     | 1001       | 3

how write query can delete duplicates? row 2 , 3 identical row 1 except different vehicleuserid , rows 5 , 6 identical 4 except different vehicleuserid.

;with cte ( select row_number() on      (partition vehicleid, userid order vehicleuserid) rn vehicleuser) delete cte rn > 1;