Re: newbie question about rownum

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 28 Aug 1998 23:30:39 +0200
Message-ID: <6s77h0$15m$1@pascal.a2000.nl>

>Err...can you have an "order by" in a subquery? I think not

Ehhh, no, of course not. Hmmm, would anyone believe that the internet has changed the group by into an order by ? :-)

So, in the sub query use the group by instead of the order by, just like Frank suggested...

Thanks for being very awake,
Arjan.

>> >Create a view of your sql statement, you cant use Order By in a view,
but
>> you
>> >can GROUP BY <name> and it will do an order by.

>> You may do the same, without actually defining a view, using a subquery:
Received on Fri Aug 28 1998 - 16:30:39 CDT