Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 9 Answers
- 12128 Views
- Zensar, I also Faced
- E-Mail Answers
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
Is trigger a stored procedure?
Explain two easy sql optimizations.
Can I learn sql in a week?
What is composite primary key in sql?
What are the types of records?
Is sqlite good enough for production?
What is database sql?
What do you mean by “trigger” in sql?
what is bcp? When does it used? : Sql dba
how many sql ddl commands are supported by 'mysql'? : Sql dba
How to order siblings in oracle hierarchy queries?
What is the difference between stored procedure and view?
How do you explain an index?
What are the different types of a subquery?
What is the maximum database size for sql express?
