db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitri Pissarenko" <dmitri.pissare...@gmail.com>
Subject Re: Views in Derby
Date Fri, 29 Jun 2007 08:28:03 GMT
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