with result as ( SELECT *, ROW_NUMBER() OVER( ORDER BY name asc ) AS seq FROM [subcats] WHERE [maincat_id]='318') SELECT * FROM result
SELECT * FROM maincats ORDER BY name