TABLE

The TABLE expression retrieves all rows from a single table.

Syntax

TABLE <table_name> 

Details

TABLE expressions can be used anywhere that SELECT expressions are valid.

The expression TABLE t is exactly equivalent to the following SELECT expression:

SELECT * FROM t; 

Examples

Using a TABLE expression as a standalone statement:

TABLE t; 

 a --- 1 2 

Using a TABLE expression in place of a SELECT expression:

TABLE t ORDER BY a DESC LIMIT 1; 

 a --- 2