Product Documentation

V9 Update Guide

Previous Topic

Next Topic

Additional ORDER BY Clause Usage

FairCom DB 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.

FairCom DB 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 FairCom DB SQL.

TOCIndex