good day for all
please help in following
In company we have a lot of employee
Company make summer resort to many place
Like place 1 ,place 2, place 3…
And we want to get ranking for each employee depend on many rules
If many employee select place1 and group1
I want ranking employees for place1 and group1
If employee select place 1 and group2
I want ranking employees for place1 and group2
If employee select place 2 and group1
I want ranking employees for place2 and group1
…
This ranking depend on
Respectively
The first
Points given to employee which are in table EMP_POINT_TB
Than
The second
Position
which are in table emp_tb
and if them I same position I need to compare them with date promotion
and if in same of promotion date compare with the hiring date
please help in following
In company we have a lot of employee
Company make summer resort to many place
Like place 1 ,place 2, place 3…
And we want to get ranking for each employee depend on many rules
If many employee select place1 and group1
I want ranking employees for place1 and group1
If employee select place 1 and group2
I want ranking employees for place1 and group2
If employee select place 2 and group1
I want ranking employees for place2 and group1
…
This ranking depend on
Respectively
The first
Points given to employee which are in table EMP_POINT_TB
Than
The second
Position
which are in table emp_tb
and if them I same position I need to compare them with date promotion
and if in same of promotion date compare with the hiring date