I am trying to select the most current record for a member on a
table. The only way to do this is by using a field called
modify_date. I've tried several things, but nothing has worked. Any
suggestions?
select case_nbr
from table_a
where member_nbr = 'xxxxxx' and
plan_type = 'xxxxxx' and
max(modify_date);
Thanks for the 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
