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...
Answer Posted / pooja gupta
select f1.a, f2.d from
(select f1 as a from t order by 1) f1,
(select f1 as d from t order by 1 desc)f2
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Can a commit statement be executed as part of a trigger?
Explain the steps needed to create the scheduled job?
what are the differences among rownum, rank and dense_rank? : Sql dba
Explain the working of primary key?
What is the use of non clustered index?
What are transaction and its controls?
what is a unique key ? : Sql dba
Which function is used to return remainder in a division operator in sql?
How do I create a memory optimized filegroup?
What is cold data?
Does sap use sql?
How can triggers be used for the table auditing?
Does mysql_real_escape_string prevent sql injection?
What is group by in sql?
what is cross join? : Sql dba