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
12458 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

Can sql function call stored procedure?

1074

What is dynamic sql in pl sql?

1090

Explain two easy sql optimizations.

1077

How much ram can sql express use?

1043

explain the advantages and disadvantages of stored procedure? : Sql dba

1067

Name the different types of indexes in sql and define them.

1226

i have some prob lem to tell me about my self in interview first round ...

2221

What is cross join sql?

964

What are the uses of merge?

1229

What is a behavioral trigger?

1027

What is recursive stored procedure?

1146

What sql database should I use?

1203

what is user defined functions? : Sql dba

1086

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

What are system versioned tables?

1076