Re: CREATE VIEW
From: rob <rob_at_dsdelft.nl>
Date: Mon, 30 Jul 2001 16:18:11 +0200
Message-ID: <9k3qb8$ihk$1_at_news.tudelft.nl>
Date: Mon, 30 Jul 2001 16:18:11 +0200
Message-ID: <9k3qb8$ihk$1_at_news.tudelft.nl>
"Tony Hunt" <tonster_at_bigpond.net.au> wrote in message
news:TVc97.74651$Xr6.343783_at_news-server.bigpond.net.au...
> I know this is a slack question. Can you use a GROUP BY clause when
> creating a VIEW?
>
> Tony
>
Why not try...
SQL>CREATE VIEW V_TEST AS SELECT SUM(V1) SV1 FROM TEST GROUP BY V1 SQL> / View created. Received on Mon Jul 30 2001 - 16:18:11 CEST