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
- 10086 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / monika
if u want to display output in two columns like f1.a,f1.b
then use
select * from(select f1 from t1)a,
select f1 from tt order by f1 desc)b);
if want to display output in same column then use union
like-
select f1 from t1
union
select f1 from t1 order by f1 desc;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is row? : Sql dba
How do we use distinct statement? What is its use?
What is bitemporal narrowing?
What is sap sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Explain what is a view?
What is difference between joins and union?
What is auto increment feature in sql?
Is pl sql different from sql?
What is the difference between partition and index?
What are the operators in sql?
explain mysql aggregate functions. : Sql dba
What is pl sql script?
can sql servers linked to other servers like oracle? : Sql dba
how to create a new view in mysql? : Sql dba
