select f1.a, f2.d from (select f1 as a from t order by 1) f1, (select f1

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 / pooja gupta

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

Answer Posted / pooja gupta

select f1.a, f2.d from
(select f1 as a from t order by 1) f1,
(select f1 as d from t order by 1 desc)f2

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is procedure function?

987

What is trigger in sql?

1032

What is the purpose of cursors in pl/sql?

1081

What is crud stand for?

940

What does 0 mean in sql?

914

Why do we need sharding?

940

Which one is better subquery or joins?

1010

What is Materialized View? In What Scenario we Use Materialized View?

9403

How much does sql cost?

933

what is the syntax for using sql_variant_property? : Transact sql

990

What is the maximum number of rows in sql table?

957

Which is better trigger or stored procedure?

883

Explain character-manipulation functions?

1070

What is loop in pl sql?

985

What is the use of sql trace?

899