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

Thanks


Mime
View raw message