desc sql

1SELECT id,  
2    first_name,
3    last_name, 
4  FROM customer
5  ORDER BY last_name ASC;
6

1//this_for_descending_order.. 
2 SELECT * FROM TableName ORDER BY columnName DESC;
3 // this_for_ascending_order..
4SELECT * FROM TableName ORDER BY columnName ASC;

1Used with ORDER BY to return the data in ascending order.
2Example: Apples, Bananas, Peaches, Raddish

1
2 SELECT * FROM Customers
3ORDER BY CustomerName DESC; 

1Used with ORDER BY to return the data in descending order.
2Example: Raddish, Peaches, Bananas, Apples