|Subject||ODP: Re: [firebird-support] SQL standard for sort fields and returned fields|
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)
-------- Oryginalna wiadomość --------
Od: "Mark Rotteveel mark@... [firebird-support]" <email@example.com>
Data: 09.05.2016 13:20 (GMT+01:00)
Temat: Re: [firebird-support] SQL standard for sort fields and returned fields
On 2016-05-09 11:45, liviuslivius liviuslivius@...
> Hi,I don't have the SQL standard at hand right now, so I can't double
> This is not specific to Firebird question but:
> is something in SQL standard specification about sorted fields must
> also returned?
> I mean:
> ORDER BY FILM_DATE, FILM_TITLE
> is [FILM_DATE] required by SQL standard or it is optional or SQL
> standard tell nothing about this?
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).