topic Re: answer to the locked thread: use maximum aggregate function in Application Development and Automation Discussions

answer to the locked thread: use maximum aggregate function

Former Member — Mon, 16 Nov 2009 16:29:04 GMT

the locked thread below is actually as different as any other unlocked thread


UP TO 1 ROWS
where
doc_number = wa_pdate_temp-salesdoc and
s_ord_item = wa_pdate_temp-salesitem and
sched_line = wa_pdate_temp-sline
order by /bic/zpviewdt descending .

The order by and up to n rows can be very expensive, better use the max(bic/zpviewdt),

for details read documentation.

Re: answer to the locked thread: use maximum aggregate function

Former Member — Mon, 16 Nov 2009 16:42:57 GMT

What thread is that Siegfried?

Rob

Re: answer to the locked thread: use maximum aggregate function

Former Member — Mon, 16 Nov 2009 18:52:22 GMT

I guess this is the one

Re: answer to the locked thread: use maximum aggregate function

Former Member — Mon, 16 Nov 2009 19:06:12 GMT

Well, that one was locked because it didn't look as if the OP had done any work to see if there was in fact a problem or done a run time analysis.

Rob