SELECT 1., 1., (SELECT TOP 1 2. FROM 1 AS 2 WHERE 2. <1. AND 2.=1. ORDER BY 2. DESC) AS , 1. AS FROM 1 ORDER BY 1.;
http://www.sql.ru/forum/1284587/hitryy-zapros