Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
XPS is supporting this syntax.
Andreas
Fred Prose wrote:
> We've been given the SQL source code for an application written to
> sql-92 standards. Some of the syntax looks like this:
>
> select
> c_count,
> count(*) as custdist
> from
> (
> select
> c_custkey,
> count(o_orderkey)
> from
> customer left outer join orders on
> c_custkey = o_custkey
> and o_comment not like
> '%express%deposits%'
> group by
> c_custkey
> ) as c_orders (c_custkey, c_count)
> group by
> c_count
> order by
> custdist desc,
> c_count desc;
>
> Correct me if I'm wrong, but I don't see that IDS 9.x supports this?
>
> Fred Prose
> Arizona Supreme Court
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.