Anish

• Jan 16th, 2016

 

Code
 

Anish

• Jan 19th, 2016

 

The below query will hold for all the possible scenarios.

Code
 

Mark Law

• Jan 23rd, 2016

 

Assuming the salary of an employee will not change in the same month,

Code
 

anagogia

• Sep 29th, 2016

 

The query has to be a nested query because one employee could have the max (year||month) = 201503 where he had max salary and other could have max(year||month) = 201603 where he had the max salary .... Inner query needs to have a joining condition with the outer query !

DATA
1 100000 2015 3
1 80000 2014 5
2 100000 2015 7
2 90000 2014 6
3 90000 2015 9
3 110000 2014 9

Code
 

SANTHOSH KUMAR GUJJA

• Nov 25th, 2017

 

SEL EMP.ID,SAL FROM
EMPLOYER QUALIFY ROW_NUMBER() OVER(PARTITION BY EMP.ID ORDER BY YEAR,MONTH DESC)=1