Re: How do you like this SQL?

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 14 Dec 2012 07:59:12 +0100
Message-ID: <aj0120FganpU2_at_mid.individual.net>

On 12/14/2012 03:00 AM, Mladen Gogala wrote:
> On Thu, 13 Dec 2012 16:55:26 -0800, John Hurley wrote:
>
>> One of my developers ... part of a very long piece of SQL near the end
>> ... lots of inline views ... and this creative piece of code:
>>
>> (
>> SELECT POC.PO_ID, POC.LINE_ITEM_PO, POC.COMMENT_PO, POC.DATE_ADD_COMMENT
>> FROM PO_COMMENT POC WHERE (POC.PO_ID,POC.LINE_ITEM_PO,POC.ROW_TIMESTAMP)
>> IN (SELECT A.PO_ID,A.LINE_ITEM_PO,MAX(A.ROW_TIMESTAMP)
>> FROM PO_COMMENT A WHERE A.TYPE_PO_COMMENT='LE' GROUP BY A.PO_ID,
>> A.LINE_ITEM_PO)
>> ) T193
>>
>> Plus of course ... PO_COMMENT is a very big table ...
>
> That SQL deserves unusual and cruel punishment. Cruel above all else.

That makes me wonder what your /usual/ punishment looks like.

Cheers

        robert Received on Fri Dec 14 2012 - 07:59:12 CET