Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 17:26:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Oracle's default behaviour with group by is to order by the grouping columns when returning the answerset.

If you add "order by deptno,mgrno,empno"

To the end of your query, you'll get the results you're looking for.

	<Prev	Next>		<<First	<Prev	Next>	Last>>