hi,
hope u'll come out from ur problem..
SELECT PRODUCT_ID,ZONE,MAX(EFFV_DATE)
FROM PL_GRP
WHERE EFFV_DATE < TO_DATE('13-JUL-09','DD-MON-YY') -- 13-JUL-09 TAKEN
AS SYSDATE
GROUP BY PRODUCT_ID,ZONE
Mayank
On Jul 10, 3:43 pm, Roopesh S <[email protected]> wrote:
> Hi There,
>
> I want to select a product_id for a zone which has a max effv_date which is
> less then sysdate. Please consider that sysdate is '13-July-2009'
>
> PS: There can be many products which in the same zone. As given in the
> example below.
>
> *Example data:*
>
> * * *product_id* * zone* * effv_date * 123 1
> 10-Jul-09 123 1 11-Jul-09 123 1 12-Jul-09 234 1 9-Jul-09 234 1 8-Jul-09 456
> 2 5-Jul-09 456 2 6-Jul-09 * *
> *Output expected*
> * *
> *product_id* *zone* *effv_date* 123 1 12-Jul-09 234 1 9-Jul-09 456 2
> 6-Jul-09
>
> Please let me know your inputs..
>
> Thanx'N'Regards
> Roopesh
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
