SQL-like syntax

After loading the sql script, you can use SQL-like syntax.

Syntax: select〔distinct〕〔 [<range-sort>] 〕〔<cols>|<expr>〕from {<table>|<join chain>}〔where <filters>〕〔by <groups>〕

In more detail about the SQL-like syntax in the description of the sql.o library.

o)\l "sql";
o)t:(+:)`a`b`c`d!(!10;!10;!10;!10);
o)select [8] M:min a,max b,last d from t where c<100, c>1 by c
c M f1 f2
---------
2 2 2  2
3 3 3  3
4 4 4  4
5 5 5  5
6 6 6  6
7 7 7  7
8 8 8  8
9 9 9  9
o)