Posted by Serge Rielau on 12/24/06 00:59
--CELKO-- wrote:
>>> Are you saying SQL shouldn't be able to answer such queries without escaping into the application? <<
>
> I would use the "ROW_NUMBER() OVER ()" that you guys at IBM put into
> DB2 !!
.... and the SQL Standard...
Well, that's what I referred to as cheating, since it requires usage
ROW_NUMBER() OVER ( _ORDER_BY_ ....). So you avoid one ORDER BY by
adding another. How come one is bad while the other isn't ?
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html
[Back to original message]
|