Delete last record from SQL Server?

Question

I want to delete the last row from my table which I have 'no' is the auto number. Could anyone help me please?

no | name | sex | phone|
1    Jack    m     343
2     tim    f     233

Answer 1

You may try this

DELETE FROM table
WHERE  no = (SELECT Max(no) FROM table)