hi,
could you explain this exception?And i also have not sql standard to look into
and need some exact confirmation about this (something like Sql92 or sql2013..
say this)
regards,Karol Bieniaszewski
-------- Oryginalna wiadomość --------
Od: "Mark Rotteveel [email protected] [firebird-support]"
<[email protected]>
Data: 09.05.2016 13:20 (GMT+01:00)
Do: [email protected]
Temat: Re: [firebird-support] SQL standard for sort fields and returned fields
On 2016-05-09 11:45, liviuslivius [email protected]
[firebird-support] wrote:
> Hi,
>
> This is not specific to Firebird question but:
> is something in SQL standard specification about sorted fields must
> be
> also returned?
> I mean:
>
> SELECT
> [FILM_DATE,]FILM_TITLE
> FROM
> FILMS
> ORDER BY FILM_DATE, FILM_TITLE
>
> is [FILM_DATE] required by SQL standard or it is optional or SQL
> standard tell nothing about this?
I don't have the SQL standard at hand right now, so I can't double
check. As far as I know, the SQL standard allows you to sort on any
field, even if it is not in the select list (with the exception of
course of ordering by column index).
Mark
