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
- 12217 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 the purpose of using pl/sql?
How do you remove duplicates without using distinct in sql?
What does closing a cursor do?
Why is sql better than hql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is scalar data type in pl sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
How can check sql version from command line?
What is a full join?
Write the command to remove all players named sachin from the players table.
How do I view a sql database?
how to use 'mysql' to run sql statements? : Sql dba
How do I make my sql query run faster?
what is blob? : Sql dba
What does pragma mean?
