Syntax

    ( Query 
         [ ORDER BY clause ]
         [ result offset clause ]
         [ fetch first clause ]
    )
 

Description Query

A query creates a virtual table based on existing tables or constants built into tables.

 
    SELECT *
      FROM <table_name>;
    

Example


   -- select all columns and records in a single table
   SELECT *
     FROM particular_table;