Thomas Hill <[email protected]> writes: > Hi, > > can anyone please confirm whether an order by clause is supported in > derby 10.5.3 or not? The manuals contain no reference to this and > reading through Jira I was under the impression that this should (now) > be possible. However when trying to create a view using a select query > which has an order by an error message Syntax Error: encountered > "ORDER" is thrown. Omitting the Create View as and executing just the > SQL query itself is working fine (so the SQL statement has no syntax > problems).
Hi Thomas, Derby 10.5.3 does not support ORDER BY in sub-queries or views. Support for this was recently added to the development source tree, and it will be supported in Derby 10.6. -- Knut Anders
