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

Is sql pronounced sequel or sql?

1247

What are the types of sql commands?

1075

What are the limitations of sql express?

1048

What is sql rowcount?

987

Which normal form is best?

937

What does desc stand for?

1058

what is the difference between char_length and length? : Sql dba

1027

What is the left table in sql?

952

What is difference between pl and sql?

1035

What are joins in sql?

1027

Write the alter statement to enable all the triggers on the t.students table.

1112

how to convert dates to character strings? : Sql dba

1141

how to rename an existing column in a table? : Sql dba

1002

what are the advantages of using stored procedures? : Sql dba

1092

Why truncate is faster than delete?

1089