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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
