db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Hill <Thomas.K.H...@t-online.de>
Subject ORDER BY in query when defining a VIEW
Date Thu, 24 Dec 2009 10:52:33 GMT

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).


View raw message