top support

[peheje]

Is the top command supported in any way?

E.g. select top 10 * from myfile

[mithrandie]

You can use limit clause or fetch clause in select query.

https://mithrandie.github.io/csvq/reference/select-query.html#limit_clause

For example, the following queries will return the results you want.

SELECT * FROM filename LIMIT 10;
SELECT * FROM filename FETCH FIRST 10 ROWS ONLY;

[peheje]

Thanks!