plz send me the query ans

[srinu_a47]

i cerated a table 'num' in that table i create a column 'sno'.
In that colum i enter the numbers 1 to 10.
my required output is
1 2 3 4 5 10 9 8 7 6

plz tell me how to display above output using sql

[shhuang]

maybe this is not a perfect idea........share to everyone

select * from (
select sno
from num
where sno <= 5
order by sno asc)
union all
select * from (
select sno
from num
where sno > 5
and sno <= 10
order by sno desc)

[ahmadbilal]

create a function with loop and in loop concat variable value to lloing value return concatednated variable