My Question is about the HXTT DBF Driver.Is there the Expression LIMIT in a SQL Statement allowed? Or is there a no support to use this expression?
Thanks for answere,
Now it doesn't support LIMIT clause, but we can provide such a support if you need. Maybe you can try TOP n [PERCENT] clause:
SELECT [ALL | DISTINCT [ ON ( expression [, ...] ) ] ] | DISTINCTROW [TOP n [PERCENT]] select-list FROM table-reference-list [WHERE condition-expression] [group-by-clause] [HAVING condition-expression] [union-clause] [order-by-clause] [FOR UPDATE].
For instance, select top 3 * from test;