Filter with WHERE Clause

The example creates an input window named TradeWindow and an output window named TradeOutWindow.

The SELECT clause returns all (*) data rows from TradeWindow. The WHERE clause places a filter on the data when the share volume is less than 10,000. As a result, the project server processes all data rows when the TradeWindow contains more than 10,000 shares.

CREATE  OUTPUT  WINDOW TradeOutWindow
	SCHEMA (
		Ts BIGDATETIME, 
		Symbol STRING, 
		Price MONEY(2), 
		Volume INTEGER)
	PRIMARY KEY (Ts)
AS
	SELECT * from TradeWindow 
	WHERE TradeWindow.Volume > 10000;