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
12075 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 does it mean to have quoted_identifier on? : Sql dba

1130

what are null values? : Sql dba

937

Is like operator in sql case sensitive?

999

What is normalization in sql?

995

What are procedures used for?

966

What do you understand by pl/sql cursors?

1070

what is sql in mysql? : Sql dba

1175

What are the types of sql commands?

1073

What are the different dcl commands in sql?

1120

Can triggers stop a dml statement from executing on a table?

1066

What is the usage of sql functions?

1128

What is a composite primary key?

1069

Is join and inner join the same?

989

What is dialect in sql?

924

What is the difference between syntax error and runtime error?

1119