I managed to get LIMIT 1 to work in Oracle.
But now I need to "LIMIT 2".
Here's the code I have for LIMIT 1 and it works great....
SELECT b.LOG_ID, b.ITEM_ID, b.ITEM_CLS, c.ITEM_NM
FROM MY_MAP a,MY_LOG b,MY_ITEM c
WHERE a.ITEM_ID = b.ITEM_ID
AND a.ITEM_ID = c.ITEM_ID
AND a.GRP_ID = '4'
AND b.ITEM_CLS = '0'
AND b.LOG_ID = (SELECT MAX(d.LOG_ID)
FROM MY_LOG d
WHERE a.ITEM_ID = d.ITEM_ID)
Any Oracle Gurus out there that can help?
