Deletes specified rows from an input window.
DELETE FROM window [ WHERE whereclause ]
window |
An input window. |
whereclause |
An expression resulting in a 1 for true, or a 0 for false. |
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.
DELETE Trades WHERE Shares < 100 and Symbol = 'SAP';