select code EMPCODE,count(date) as 'CONTINUOUSLEAVEFORHOWMUCHDAYS' from employee where date = '01/02/2020' group by Code Accept solution if you are happy with the solution
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)