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
11861 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

How to read/write files from pl/sql?

994

What is pl sql quora?

1074

Can we create foreign key without primary key?

935

What is the life of an sql statement?

964

What is pl sql architecture?

925

How can get second highest salary in sql?

914

Explain what is an index?

1001

How do I partition a table in sql?

1046

What is lexical units in pl sql?

1056

What is online transaction processing (oltp)?

964

Why do we need sharding?

940

what is single byte over head in oracle..?

2346

What is the use of nvl function?

1128

Is the primary key an index?

985

What is orm in sql?

995