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
- 11852 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
What is rownum?
Are there any features that are decommissioned in 11g that are not present in 11g?
What does trigger mean in slang?
how to create a new table in mysql? : Sql dba
What are pl sql data types?
What is the difference between clustered and non-clustered indexes?
What is pl sql architecture?
What does partition by mean in sql?
What is normalization? How many normalization forms are there?
what are the authentication modes in sql server? : Sql dba
Explain what is sql?
What are sql queries used for?
What is sqlcontext?
How run sql*plus commands that are stored in a local file?
Why we use pl sql?
