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
12197 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 does inner join mean?

1167

What is pivot query?

1071

what is sql server agent? : Sql dba

1103

How do you create a db file?

1016

State few characteristics of pl/sql?

971

What is the current version of postgresql?

1067

How to use distinct and count in sql query? Explain

1023

explain advantages of myisam over innodb? : Sql dba

1069

What are different types of indexes?

1010

What is string join?

978

What is sqlservr exe?

977

Is mariadb a nosql database?

1055

What is data type in sql?

963

what is a relationship and what are they? : Sql dba

1101

what happens if you no create privilege in a database? : Sql dba

1001