ORDER BY DESC in Teradata

To sort highest to lowest, DESC must be supplied with ORDER BY.

Syntax:
SELECT columnname
FROM tablename
ORDER BY columnname ASC | DESC


Example:
SELECT * from tbl_book;

idnamepriceAuthor
5C#190.9900Johnson
3Apache110.9900Gerald
1Teradata150.9900Frost
6Unix180.9900gille
4LINQ150.9900Joyce
2SQL130.9900Miller


SEL * FROM tbl_book ORDER BY id ASC;

idnamepriceAuthor
1Teradata150.9900Frost
2SQL130.9900Miller
3Apache110.9900Gerald
4LINQ150.9900Joyce
5C#190.9900Johnson
6Unix180.9900gille


SEL * FROM tbl_book ORDER BY id DESC;

idnamepriceAuthor
6Unix180.9900gille
5C#190.9900Johnson
4LINQ150.9900Joyce
3Apache110.9900Gerald
2SQL130.9900Miller
1Teradata150.9900Frost