select * from (select f1 from t1 order by f1 asc) union all select * fr

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

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

Answer Posted / anjum

select * from (select f1 from t1 order by f1 asc)
union all
select * from (select f1 from t1 order by f1 desc)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is java sql drivermanager?

1161

Define implicit and explicit cursors.

1207

What is pl sql block structure?

1095

What is sql query optimization?

1193

what are date and time intervals? : Sql dba

1105

is it possible to pass an object or table to a procedure as an argument?

1178

How many sql databases can you have on one server?

1153

What is a primary key sql?

1093

Explain what is sql?

1181

What is the maximum number of rows in sql table?

1079

What is normalization in a database?

1198

What is gpt format?

992

what are myisam tables? : Sql dba

1077

What are conditional predicates?

1127

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1058