Count Record Which Met Condition

SQL use for count the number of record which met the condition

SELECT count(*any_variable_in_the_table) FROM *what_table WHERE *condition


select count(idpayrolldaily) FROM payrolldaily WHERE idpayslip =30123 and is_full_shift=1 and is_absent=0