DELETE Statement

Deletes specified rows from an input window.

Syntax

DELETE FROM window  [ WHERE whereclause ]

Components

window	An input window.
whereclause	An expression resulting in a 1 for true, or a 0 for false.

Usage

The DELETE statement removes specified rows from an INPUT window. It cannot be used with streams. The WHERE clause acts a filter which limits which rows are deleted. If a WHERE clause is not provided all rows in the input window are deleted.

Note that you cannot use esp_query to run concurrent DELETE statements on the same window or stream.

Example

DELETE Trades WHERE Shares < 100 and Symbol = 'SAP';