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
12139 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 the difference between clustered and non clustered index in sql? : Sql dba

1116

how would you enter characters as hex numbers? : Sql dba

974

What is the difference between function and procedure in pl/sql?

1069

Which are the different case manipulation functions in sql?

1014

Which normal form is best?

948

What is crud stand for?

992

What is substitution variable in pl sql?

1038

What does cursor do in sql?

1011

What is clause in sql?

1106

Is postgresql a nosql database?

1149

What is partition by in sql?

1059

What is rowtype?

1007

What are literals in sql server?

1158

how to drop an existing index in mysql? : Sql dba

1060

What is plpgsql language?

1055