if u want to display output in two columns like f1.a,f1.b then use select

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...

Question Posted / monika

9 Answers
12137 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

Please Help Members By Posting Answers For Below Questions

What is the starting oracle error number?

1048

What is the purpose of a sql?

971

Explain the uses of control file.

1043

What is sqlca in db2?

948

what is the use of friend function? : Sql dba

1015

Explain isolation levels. : Transact sql

1060

What is the difference between null value, zero, and blank space?

1195

Write an sql query to select all records from the table?

1012

what is datawarehouse? : Sql dba

1005

how mysql optimizes distinct? : Sql dba

1071

What are the types of variable use in pl sql?

1066

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1085

How to run sql*plus commands in sql developer?

1144

What version is sql?

1017

What view means?

971