oracle functions

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RPPORTER
    New Member
    • Oct 2008
    • 1

    oracle functions

    I am a newbie to Oracle functions and need help with a function. I am trying to create a report to show only those accounts/customers with an activity date/invoice date from January 1, 2007 to the present. I only want one row returned per customer account, the row with the last activity date. Can you please help??
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    You need to use Group by to achieve that.

    Comment

    Working...