Subject | Re: [Firebird-Architect] Re: Standard Conformance |
---|---|
Author | Daniel Rail |
Post date | 2003-06-19T12:03:43Z |
Hello peter_jacobi.rm,
Thursday, June 19, 2003, 4:31:03 AM, you wrote:
pr> In this case I must guess, that UNION DISTINCT is in SQL:99
pr> but not in SQL:92. Anyway, it's really not the most important
pr> feature, I concede.
You are correct in assuming that UNION DISTINCT is in SQL-99, and not
in SQL-92. But, in SQL-99, if UNION is specified and neither ALL nor
DISTINCT is specified, then DISTINCT is implicit. So, as you can see,
it is not required.
--
Best regards,
Daniel Rail
Thursday, June 19, 2003, 4:31:03 AM, you wrote:
pr> In this case I must guess, that UNION DISTINCT is in SQL:99
pr> but not in SQL:92. Anyway, it's really not the most important
pr> feature, I concede.
You are correct in assuming that UNION DISTINCT is in SQL-99, and not
in SQL-92. But, in SQL-99, if UNION is specified and neither ALL nor
DISTINCT is specified, then DISTINCT is implicit. So, as you can see,
it is not required.
--
Best regards,
Daniel Rail