There is a table which tracks changes made to an account Account Number Action Date ----------------------------------------------------------- 1234 Open 11/01 1234 Upgrade 11/02 6666 Open 11/04 1234 Close 11/05 6666 Upgrade 11/05
Whats the query to get all accounts not closed(still open) on a given month? In this case for month 11 it should return 6666 this table can have millions of entry on a given month. help!!! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
