select a.f1 f1.a,b.f1 f1.b from t1 a t1 b order by a.f1 asc,b.f1 desc;

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 / sowmya

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

Answer Posted / sowmya

select a.f1 f1.a,b.f1 f1.b
from t1 a t1 b
order by a.f1 asc,b.f1 desc;

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a left join?

935

Is join an inner join?

947

What is the cause of mutating table error and how can we solve it?

1036

What is exception? What are the types of exceptions?

1060

What version is sql?

1007

what is a database transaction? : Sql dba

1153

how to show all tables with 'mysql'? : Sql dba

1092

How exception handling is done in advance pl/sql?

965

what is a database? : Sql dba

1143

Is coalesce faster than isnull?

954

How do you write a complex sql query?

1044

what is timestamp in mysql? : Sql dba

1055

Why is the cursor important?

1022

What is full join?

934

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1045