Re: Make ORDER BY in a view?

Hi,

You can force a order by into a view by using UNION (it has an implicit order by):

select first_preferred_column, next_preferred_column, third_preferred_column from my_table
UNION
select first_preferred_column, next_preferred_column, third_preferred_column from my_table;

I presume it will take some extra processing...

Grt Received on Fri Dec 11 1998 - 16:55:52 CST