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
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
thanks i used the select top 20 and copied them back.