Re: Create view with Order By

From: Rudy Zung <_spamkill_zungr_at_prograph-inc.com>
Date: Tue, 13 Apr 1999 13:11:09 -0400
Message-ID: <7evtnk$mt6$1@mailhost.prograph-inc.com>

Neil Moseley wrote in message <37135BDB.73449C6_at_iinet.net.au>...
>G'day all,
>
>This statement works fine:
>SELECT * FROM MYTABLE ORDER BY MYCOLUMN;
>But this does not:
>CREATE VIEW TEMP AS SELECT * FROM MYTABLE ORDER BY MYCOLUMN;
>
>If ORDER BY cannot be used when creating a view, is there a solution.
>
>Thankyou
>
>Neil Moseley

You can't have an ORDER BY in a view; but, I believe you can use a side-effect of GROUP BY to accomplish an implicit sort within your view.

...Ru Received on Tue Apr 13 1999 - 12:11:09 CDT