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 / 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
Why plvtab is considered as the easiest way to access the pl/sql table?
What is the life of an sql statement?
What are the two characteristics of a primary key?
How do I remove duplicates in two columns?
what is an index? : Sql dba
What is the function that is used to transfer a pl/sql table log to a database table?
what is the command line end user interface - mysql? : Sql dba
How to write a query to show the details of a student from students table whose
What is the difference between a query and a report?
Explain the uses of a database trigger?
what are the different type of normalization? : Sql dba
Is sql port 1433 encrypted?
What does select * from mean in sql?
What are the possible values for the boolean data field?
Explain the working of primary key?