SQL query help

[gigemboy]

Arnoutdv said it best.

Here's a pretty version (defensive in case ctime is not distinct)

DELETE MT
FROM   dbo.MyTable AS MT
WHERE  MT.id =
(
    SELECT TOP (1) id
    FROM   dbo.MyTable
    ORDER BY
           ctime,
           id
)