SQL Commands

SELECT

SELECT statement [ON [CURSOR] cursor] [WITH options]

The SELECT command, like a standard SQL Select statement, selects and retrieves rows from a database based on the given criteria. Standard SQL syntax is supported for the SELECT command, along with the Omnidex extensions to the SQL standard.

Syntax

SELECT statement [ON [CURSOR] cursor] [WITH options]

SELECT

Required

statement

Required.

ON [CURSOR] cursor

Optional - Specify which cursor to perform this command on.

[WITH options]

Optional - Specify options to be used for this command.

See SELECT Statement Syntax for details about valid statements.

top