ebird-support@yahoogroups.com>
Onderwerp: [firebird-support] SQL standard for sort fields and returned fields
Datum: ma, mei 9, 2016 23:54
Perfect
On Monday, May 9, 2016 8:48 PM, "'Mark Rotteveel' m...@lawinegevaar.nl
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
select list, so by definition that
column needs to be in the list.
Mark
- Bericht beantwoorden -
Van: "liviusliv...@poczta.onet.pl [firebird-support]"
<firebird-support@yahoogroups.com>
Aan: <firebird-support@yahoogroups.com>
Onderwerp: [firebird-support] SQL standard for sor
ebird-support@yahoogroups.com>
Aan: <firebird-support@yahoogroups.com>
Onderwerp: [firebird-support] SQL standard for sort fields and returned fields
Datum: ma, mei 9, 2016 21:40
Hi,
i am talking about your post
“I don't have the SQL standard at hand right now, so I can't double
check. As
Hi,
i am talking about your post
“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).”
and about line
On 2016-05-09 15:29, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> 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)
I see no exception, did
@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Montag, 9. Mai 2016 16:30
To: firebird-support@yahoogroups.com
Subject: ODP: Re: [firebird-support] SQL standard for sort fields and returned
fields
hi,
could you explain this exception?
And i also have not sql standard to look
ebird-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, livius
On 2016-05-09 11:45, liviuslivius liviusliv...@poczta.onet.pl
[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
>
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