ORACLE SQL - to get the first_value and the last_value using OVER PARTITION BY
Posted on 2007-10-04
I have a table cnam_load which is Oracle table and the columns of the table are :-
I have to use the over partition by command to get the first value and the last value of the action_type and it should be grouped by mdn and count(*) > 1. I never used over partition by command and I am not sure how to build this query. I would appreciate your advice.