SQL LIMIT with AcuXDBC

0 Likes

Problem

AcuXDBC does not support the SQL LIMIT function.

 MySQL has a LIMIT function which does what it implies.  For example this returns only the first row:

      SELECT * FROM MYTABLE LIMIT 1;

When doing this with AcuXDBC there is a syntax error reported.

Solution

AcuXDBC supports use of the TOP function to accomplish the same thing.  This returns only the first row:

     SELECT TOP 1 * FROM MYTABLE;

Comment List
Anonymous
Related Discussions
Recommended