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

• Next in forum: Re: ORDER BY CASE
• Prev in forum: Re: How to search binary fields?
• Thread view: Re: ORDER BY CASE

[Reply to this message]