Re: Make ORDER BY in a view?

suisum_at_ecn.ab.ca schrieb:
>
> Hi:
>
> I know that we can't use ORDER BY in a view. Is there any way to get
> around this?
>
> --
> Best regards,

One thing that may help you is to add a group by clause to your statement:

CREATE VIEW emp_test as

	SELECT 
		ENAME,
		EMPNO
	FROM
		EMP
	GROUP BY
		ENAME,
		EMP;

GROUP BY makes an implicit sort.

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Fri Dec 11 1998 - 05:42:55 CST