select Count(*) from Emp where date= current_date-1;

X(Table name)  - Eg: Emp
Result set           120