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 does a covering index work?
How to change sql*plus system settings?
Can a table contain multiple foreign key’s?
How do I create a sql database?
How do I find duplicates in a single column in sql?
What is the limitation on the block size of pl/sql?
How many types of index are there?
What is clustered index in sql?
What is Difference Between Unique and Primary Key Constraints?
What are sql functions? Describe in brief different types of sql functions?
What are the usages of sql?
What is indexing in sql and its types?
Describe sql comments?
Can I join the same table twice?
what is the difference between undefined value and null value? : Sql dba