Create Table #Test (a int, b int, C as a+b )

go

insert into #test values (3,4)

insert into #test values (1,7)

go

select * from #test

order by 1

go

drop table #test

go

Isn't it funny that when you say order by 1, sql server assumes 1 as column and gives result order by column 1 but at the same time when you execute

select 1 from #test

you get result as 1