Start Free Trial

Farzad Akbarnejad

asked on 5/16/2011

Last Function in Group By Query in Oracle

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

Oracle Database SQL

Last Comment

Guy Hengel [angelIII / a3]

5/16/2011

ASKER CERTIFIED SOLUTION

5/16/2011

Blurred text

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

5/16/2011

>I want to distinct (or group by) on RWSHID and RISUID and select last JOBCODE in each row.

But there is only one JOBCODE in each row.
And what do you mean by "last"; there is no date in evidence

Is this what you mean:

Select RWSHID, RISUID max(JOBCODE) group by RWSHID, RISUID

Guy Hengel [angelIII / a3]

5/16/2011

you might want to read this article: https://www.experts-exchange.com/A_3203.html
will also show how to do it (with row_number() function)

this will be very useful if you need other rows also from the same table.

Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K

Questions

--

Followers

--

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY