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 / 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 full join in sql?
What is the difference between a primary key and a clustered index?
How many tables can you join in sql?
What are sql data types?
What is embedded sql in db2?
What is a native sql query?
What is trigger types in sql?
Enlist some predefined exceptions?
How to write pl sql program in mysql command prompt?
What is normalization sql?
What is a mutating table and a constraining table?
Which is better trigger or stored procedure?
What does fetching a cursor do?
What is user in sql?
Explain what is sql*plus?