SQLTeam.com | Weblogs | Forums

Removing all data after you find the top 20 values

Hi

what is the best way to selecting the top 20 records values wise from a column and then deleting the rest out of the tasble

Use row_number or select top 20 into new table, truncate and copy back

1 Like

thanks i used the select top 20 and copied them back.