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 / venkyhulk1
if the output need to be displayed in two columns f1.a , f1.b
the querry will be
select a.f1 "f1.a", c.f1 "f1.b"
from (select rownum r1, f1 from t1) a,(select rownum r1,b.f1
f1 from (select f1 from t1 order by f1 desc) b) c
where a.r1=c.r1
hope this is the shortest querry that one can write in sql
to get this task done .
if u try it in other ways as shown above it will perform
catesian product which results in more rows than required .
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can I see all tables in sql?
What is normalization in a database?
Why do we use procedures in sql?
What is foreign key and example?
What are the various levels of constraints?
What is sharding in sql?
How to set up sql*plus output format in oracle?
What is materialized view in sql?
Why use stored procedures?
What is integrity in sql?
What is a Mapplet?
Which are the different character-manipulation functions in sql?
How do I run sql?
What are pl sql data types?
How can I delete duplicate rows?