select * from (select f1 from t1 order by f1 asc) union all select * fr

take one table is t1 and in that column name is f1
f1 column values are
200
5000
3000
7000
300
600
100
400
800
400
i want display the values asc and desc in a single output.
sample output is
f1.a
100
200
300
400
500
600
etc......
and f1.d is
5000
4000
3000
2000
1000
etc...

Question Posted / anjum

9 Answers
12086 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / anjum

select * from (select f1 from t1 order by f1 asc)
union all
select * from (select f1 from t1 order by f1 desc)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are pl sql variables case sensitive?

1032

what is log shipping? : Sql dba

1093

Which one is better sql or oracle?

949

What is difference between pl and sql?

1035

What is autocommit sql?

969

What is restrict in sql?

1092

Describe types of sql statements?

1046

Can unique keys be null?

882

Do stored procedures prevent sql injection?

954

Does a join table need a primary key?

941

how to include character strings in sql statements? : Sql dba

1046

What is primary key secondary key alternate key candidate key?

1016

What is case function?

1019

What is type and rowtype in pl sql?

1007

What is the use of pl/sql table?

1047