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
12216 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 basic structure of an sql?

1108

what is a composite primary key ? : Sql dba

1057

What are properties of the transaction?

998

How many clustered indexes can you have?

975

What are types of indexes in sql?

1084

What is date functions?

1036

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1006

How do temporal tables work?

966

How do I start pl sql?

954

Can cursors be part of a trigger body?

1641

What is the use of sqlerrd 3?

945

what is sql in mysql? : Sql dba

1200

What are the two virtual tables available at the time of database trigger execution?

1227

Define the select into statement.

1063

What are stuff and replace function?

1091