DELETE Statement

Deletes specified rows from an input window.

Syntax

DELETE FROM window  [ WHERE whereclause ]

Components

window	An input window.
whereclause	Deletes rows that match the whereclause condition.

Usage

The DELETE statement removes specified rows from an INPUT window. It cannot be used with streams. The WHERE clause acts as 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';