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
11853 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 are some emotional triggers?

931

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

993

Why do we use subquery?

944

What is raid? How does it help storage of databases?

1035

Is hadoop a nosql?

950

What is sqlservr exe?

943

What are the methods of filing?

878

What is varchar example?

975

What is the difference between sql and mysql?

1055

What is the difference between a primary key and a unique key?

1001

What are the built in functions of sql?

983

What is auto increment in sql?

1063

Does sqlite need a server?

995

what is bdb (berkeleydb)? : Sql dba

976

what are rollup and cube in t-sql? : Transact sql

1049