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...
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
How do you optimize a stored procedure in sql?
What are the different type of joins in sql?
Is pl sql a scripting language?
Is hadoop a nosql?
What is sql and db2?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How do I truncate a sql log file?
What are the types of variable use in pl sql?
What are local and global Indexes and where they are useful.
how to check myisam tables for errors? : Sql dba
How to run sql*plus commands in sql developer?
What is loop in pl sql?
How do I truncate a word?
How is a process of pl/sql compiled?
What is the order of sql select?