How do you like this SQL?
From: John Hurley <johnthehurley_at_gmail.com>
Date: Thu, 13 Dec 2012 16:55:26 -0800 (PST)
Message-ID: <bd873b2b-24bd-43e5-a0ba-9329eb72c616_at_f19g2000vbv.googlegroups.com>
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:
Date: Thu, 13 Dec 2012 16:55:26 -0800 (PST)
Message-ID: <bd873b2b-24bd-43e5-a0ba-9329eb72c616_at_f19g2000vbv.googlegroups.com>
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 ... Received on Fri Dec 14 2012 - 01:55:26 CET