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
What are sql queries used for?
how to check server status with 'mysqladmin'? : Sql dba
what is a composite key ? : Sql dba
What are the benefits of pl sql?
How do I save the results of sql query in a file?
What is the full form of sql?
Is sql procedural language?
how can we repair a mysql table? : Sql dba
How do I install microsoft sql?
Can instead of triggers be used to fire once for each statement on a view?
Which is better varchar or nvarchar?
What is sql table?
how many ways we can we find the current date using mysql? : Sql dba
What is sqlerrm?
Define the select into statement.