We help IT Professionals succeed at work.
Get Started

Last Function in Group By Query in Oracle

379 Views
Last Modified: 2013-12-07
Hello,

I have a table with the following data:


            RWSHID            RISUID       JOBCODE
  ---------------------------------------------------------
      0188280314      0010202751      000000
      0188280314      0010202751      024019
      0188280314      0010202751      024043
      0188280314      0010424521      000000
      0188280314      0010424521      024043
      0188280314      0010424521      027212
      0188280314      0010454707      007005
      0188280314      0010454707      024019
      0188280314      0010454707      024043
      0188280314      0010661047      024043
      0188280314      0010661047      027075
      0188280314      0010667463      024019
      0188280314      0010667463      024032
      0188280314      0010667463      024043
      0188280314      0010684834      000000
      0188280314      0010684834      001094
            ...........           ...............       ...........
            ...........           ...............       ...........
            ...........           ...............       ...........
            ...........           ...............       ...........

I want to distinct (or group by) on RWSHID and RISUID and select last JOBCODE in each row.
Would you please send me the query run in Oracle (PL/SQL)

Thanks
-FA


Comment
Watch Question
Top Expert 2009
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE