select a,d from (select a,d,rownum as n from (select f1.a, f2.d from (se

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...

Question Posted / innaci

9 Answers
12136 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / innaci

select a,d from (select a,d,rownum as n from (select f1.a,
f2.d from
(select f1 as a from sample1 order by 1) f1,
(select f1 as d from sample1 order by 1 desc) f2) temp)
temp1 where mod(n,(select count(f1) from sample1)+1)=1

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is compiled query?

1028

What is schema in sql example?

1169

explain mysql aggregate functions. : Sql dba

980

how to get a list of columns in an existing table? : Sql dba

954

how to return query output in html format? : Sql dba

1068

What does joining a thread mean?

1014

Is natural join same as inner join?

922

Why do we use set serveroutput on?

961

What trigger means?

971

What is union?

1153

Is join same as left join?

1029

what is the stuff function and how does it differ from the replace function? : Sql dba

1037

How to use sql*plus built-in timers?

1183

what is a database lock ? : Sql dba

1158

Can a table have no primary key?

1050