top

The top clause is used to specify the number of records to return. Specify a scalar after the keyword to select the first N number of records, or specify a range (with exclusive lower bound) to select the records within the range. Note that the first row is at index 0, not index 1.

Examples

sym = `C`MS`MS`MS`IBM`IBM`C`C`C$SYMBOL
price= 49.6 29.46 29.52 30.02 174.97 175.23 50.76 50.32 51.29
qty = 2200 1900 2100 3200 6800 5400 1300 2500 8800
timestamp = [09:34:07,09:36:42,09:36:51,09:36:59,09:32:47,09:35:26,09:34:16,09:34:26,09:38:12]
t1 = table(timestamp, sym, qty, price);

t1;

select top 3 * from t1;


timestamp	sym	qty	price
09:34:07	C	2200	49.6
09:36:42	MS	1900	29.46
09:36:51	MS	2100	29.52

select top 2:4 * from t1;


timestamp	sym	qty	price
09:36:51	MS	2100	29.52
09:36:59	MS	3200	30.02

The scalar or range specified in the ## top clause must be an integer(s). Variables or expressions are not supported.

x=2;
select top x * from t1;
// output
Syntax Error: [line #2] integer constant expected after keyword top

select top (1+2) * from t1;
// output
Syntax Error: [line #1] integer constant expected after keyword top

The top clause cannot be used with the pivot by clause. It can be used with the group by clause or the context by clause (see context by).