Oracle Analytic Function [message #411075] |
Wed, 01 July 2009 15:51  |
Shankar Swamy
Messages: 2 Registered: October 2000
|
Junior Member |
|
|
Wanted to make sure to pick the correct analytic function.
For a table with Person id , there can be multiple rows
Those rows will fall under the category of one Log id , and one Log id can have multiple Log sequence
For e-g
Person id Log id Log seq Log desc
1234 1 0 YYYY
1234 1 1 YYYY
1234 1 2 error
1234 2 0 XXXX
1234 2 1 .....etc
If I need to find out the max seq for each Log id , and reject all Log id with max seq = 'error' , then will the LAST_VALUE or LAST_FUNCTION will work.
Thx,
SS
|
|
|
|
|
|