How do you order by rows in a view?

From: Youichi Tamura <y-tamura_at_nriws11.nri.co.jp>
Date: Fri, 16 Dec 1994 12:20:44 GMT
Message-ID: <D0wKyK.Hrx_at_nrigw11.nri.co.jp>

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.

How else can you do it?

-- 
							Yoichi Tamura
							y-tamura_at_nri.co.jp

Received on Fri Dec 16 1994 - 13:20:44 CET

This message: [ Message body ]
Next message: Alvin Law: "Re: How do you order by rows in a view?"
Previous message: Mohammed Ghouse: "optical disk"
Next in thread: Kenneth Ho: "Re: How do you order by rows in a view?"
Reply: Alvin Law: "Re: How do you order by rows in a view?"
Reply: Kenneth Ho: "Re: How do you order by rows in a view?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message