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
12103 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 the difference between view and stored procedure?

955

What is the difference between the conventional and direct path loads? : aql loader

1378

How do I view tables in mysql?

960

Why do we create stored procedures & functions in pl/sql and how are they different?

930

What is delimiter sql?

969

what are the advantages a stored procedure? : Sql dba

967

Does truncate release storage space?

1064

Explain the purpose of %type and %rowtype data types with the example?

976

What is a native sql query?

1045

Can primary key be changed?

896

How many developers work on postgresql?

958

explain the difference between bool, tinyint and bit. : Sql dba

978

What is the advantage of nosql?

1048

What does bitemporal mean?

1053

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1003