Sorting Data by Assending order

[sayma]

Hi ,

I want to show my data by Assending Order. Is it possible. I can by Descending order but can't by Assending. Can Any one help me..

sayma

[[deleted]]

change
ORDER BY xxx DESC
to
ORDER BY xxxx ASC

Hint: do some reading on the SQL syntax

[nightowl]

just leaving ASC away works aswell..;

[[deleted]]

True, but that's only because most databases assume you mean ASC by default. It's only four extra characters bnut ensures that you will always get what you want, and not what the database thinks you want.