Descending Sort Select Oracle Database Tutorial Example

How To Descending Sort/Order Data IN Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to select data sorting descendingly from a table in Oracle Database Server Tutorial Example

-- CONNECT as TUTORIAL
-- i am using sqlplus as client. you can use anything as you like.
 
   SELECT * FROM test ORDER BY TestName DESC;
      -- that's it!! all rows & columns of Oracle database table "test" have been selected
      -- Sort or Order Descendingly By TestName

      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Descending Sort/Order Data IN Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Ascending Sort/Order Data In Oracle Database Tutorial Example
  2. How To Update Data In Oracle Database Tutorial Example
  3. How To Update Specific Rows In Oracle Database Tutorial Example
  4. How To Delete Specific Rows Data From Oracle Database Tutorial Example
  5. How To Delete Data From Oracle Database Tutorial Example
  6. How To Use COMMIT ROLLBACK In Oracle Database Tutorial Example
  7. MySQL NULL Values in SQL Arithmetic Expressions Example
  8. How To Find MySQL SERVER VERSION Information
  9. 19 Examples to Learn MySQL
  10. UNIX Command Example: rmdir - Remove directory(ies)
  11. 20 Steps to Learn CakePHP by Example

No comments:

Post a Comment

leave your comments here..