tags:

views:

267

answers:

1

Hi,

How can I remove a row from a table that has lowest rowid? Thank you.

+6  A: 
DELETE
  MyTable
WHERE
  Id = (SELECT MIN(Id) FROM MyTable)
Tomalak