Skip to Content
0
Former Member
Oct 13, 2005 at 05:34 AM

help needed in the logic

28 Views

i hav select query like this:-

SELECT COUNT(*) INTO NO_OF_WORKERS FROM PA0000

WHERE ENDDA = '99991231' AND STAT2 = '3'.

with this select query , i can get the no. of workers .

How can i get the no. of workers in the recording period <u><b>excluding</b></u> those persons who were absent from work on paid/unpaid leave for the entire period?