db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruska <peter.ondru...@gmail.com>
Subject Re: Views in Derby
Date Fri, 29 Jun 2007 13:18:05 GMT
OK, sorry, forgot to name the inner table (x):

SELECT * FROM (your_SELECT_with_GROUP_BY) x ORDER BY ...

On 29.6.2007, at 10:28, Dmitri Pissarenko wrote:

> Hello!
>
> On 6/28/07, Peter Ondruska <peter.ondruska@gmail.com> wrote:
>> SELECT * FROM (your_current_SELECT_statement_with_GROUP_BY) ORDER  
>> BY ...
>
> Thanks for your answer!
>
> When I do this, I'm getting this error:
>
> SQL State = 42X01 SQL Code = 30000 SQL Message = Syntax error:
> Encountered "ORDER" at line 5, column 1. Exception message =
> java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at
> line 5, column 1.
>
> Best regards
>
> Dmitri Pissarenko
> -- 
> http://www.xing.com/profile/Dmitri_Pissarenko
> http://dapissarenko.blogspot.com/


Mime
View raw message