sql语句Order by 报错列名不明确

select top 10 column1,column2,column3 from table1 where table1.id not in(select top 0 table1.id from table1 order by column1 asc) order by column1 ascselect top 10 column1,column2,column3 from tabl