Hi ,
I have a scenario to find the next sal from the employee table like if the two salaries are same it should not show the next salary to the same instead it should show the next bigger salary like below
Suppose I have
Empid Sal
1 2000
2 3000
3 3000
4 5000
So for employee_id 2 , the next salary I am expecting to be 5000 which is the next bigger salary for 3000 , So for both the records the next salary to be 5000.
Is it possible using lead function.
I have one more query , What is the default windowing clause in the analytical function is it unbounded preceding and current row.
Please share your valuable thoughts
Regards,
Prafull