desc sql code example

Example 1: how to sort names in alphabetical order in sql

SELECT id,  
    first_name,
    last_name, 
  FROM customer
  ORDER BY last_name ASC;

Example 2: sql asc

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

Example 3: order by sql

//this_for_descending_order.. 
 SELECT * FROM TableName ORDER BY columnName DESC;
 // this_for_ascending_order..
SELECT * FROM TableName ORDER BY columnName ASC;

Example 4: sql desc

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

Tags:

Sql Example

Related