Previous Topic

Next Topic

Additional ORDER BY Clause Usage

c-treeACE SQL previously did not support an ORDER BY clause in a subquery. This support has been added. Note however, subqueries with a combination of TOP, GROUP BY and outer references remain unsupported.

c-treeACE SQL now also supports an ORDER BY clause in a FOR UPDATE query.

Note: This is a non-standard SQL feature as specified by SQL92. Additionally, full cursor update is not supported by c-treeACE SQL.