#The ORDER BY keyword is used to sort the result-set by a #specified column

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 / jitendra

9 Answers
12209 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / jitendra

#The ORDER BY keyword is used to sort the result-set by a #specified column.
#The ORDER BY keyword sort the records in ascending order by #default.
#If you want to sort the records in a descending order, you #can use the DESC keyword.

#1. display the values ascending order

SELECT f1 FROM t1 ORDER BY f1 AS f1.a

#2. display the values descending order

SELECT f1 FROM t1 ORDER BY f1 DESC AS f1.d

Is This Answer Correct ?

0 Yes

15 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what is a subquery ?

1191

What are different sql data types?

1051

What is sap sql?

988

Which tcp/ip port does sql server run?

1014

what is a record in a database ? : Sql dba

1067

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1002

What is a boolean in sql?

985

What is on delete restrict?

1004

What is data types in sql?

1011

When is a declare statement required?

1145

Why do we use cursors?

991

what is transaction? : Sql dba

1011

What does a pl/sql package consist of?

979

What does desc stand for?

1075

Does db2 use sql?

952