| Subject | ODP: Re: [firebird-support] SQL standard for sort fields and returned fields |
|---|---|
| Author | liviuslivius |
| Post date | 2016-05-09T14:29:50Z |
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 mark@... [firebird-support]" <firebird-support@yahoogroups.com>
Data: 09.05.2016 13:20 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: [firebird-support] SQL standard for sort fields and returned fields
On 2016-05-09 11:45, liviuslivius liviuslivius@...
[firebird-support] wrote:
> 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
> 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?
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