Re: How do you order by rows in a view?

In article <D0wKyK.Hrx_at_nrigw11.nri.co.jp> y-tamura_at_nriws11.nri.co.jp (Youichi Tamura) writes:

>You can't use order by with a create view statement.
>So you're supposed to use group by instead. It works.
>What I want to do, however, is to sort the rows in a
>descending order, and, apparently, group by clause does
>not take [desc] parameter, as does order by.

Try:
select * from <your_view> order by 1 desc

>How else can you do it?
>--
> Yoichi Tamura
> y-tamura_at_nri.co.jp

Hope this help

Ken Received on Mon Dec 19 1994 - 12:03:05 CET