SELECT * FROM ( SELECT TOP (1) * FROM myTable ORDER BY name ASC ) Or SELECT t.* FROM ( SELECT * FROM myTable ) as t ORDER BY t.name ASC