Re: Select one row

Sven Heins wrote in message <3649547F.F43715CE_at_solution42.de>...
>
>try ...where rownum = 1...

Which works fine, except when you get to aggregation, where it will only aggregate 1 row instead of returning the 1st row of the aggregation row set.

What about?

SELECT * FROM (the actual select goes here) WHERE rownum = 1

regards,
Billy Received on Wed Nov 11 1998 - 06:53:11 CST