Descending Sort Order MySQL Data Tutorial Example

How To Descending Sort/Order MySQL Data Tutorial Example

Open your MySQL Query Editor then copy & paste the below code to select or retrive data descendingly sort or order from a database table "test" in MySQL Database Server

-- How To Descending Sort/Order MySQL Data Tutorial Example

SELECT * FROM test ORDER BY TestName DESC;

-- that's it!! all rows & columns of mysql database table "test" have been selected
-- Sort or Order By TestName Descendingly
      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Descending Sort/Order MySQL Data Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

  1. MySQL NULLIF() Nested Function Example
  2. MySQL TRUNCATE TABLE Example
  3. Parentheses in SQL Command MySQL Example
  4. Aliase column name in SQL Command MySQL Example
  5. Operator precedence in SQL Command MySQL Example
  6. Arithmetic operators in SQL Command MySQL Example
  7. MySQL Stored Procedure: Variable Example
  8. 20 steps to make CakePHP Blog Project

No comments:

Post a Comment

leave your comments here..