count() returns me 0 always

navedjobs · #1 (**permalink**) 12-03-11, 09:07

Code:

select count(Emp_status) from emp_att where Emp_status = 'Present' and emp_id = 1

this return me 0 always even though there is an employee with emp_id = 1
and emp_status = 'Present' and date = '2-jan-2012'
why so , any help please ?

navedjobs · #2 (**permalink**) 12-03-11, 09:43

Quote:

Originally Posted by navedjobs

Code:

select count(Emp_status) from emp_att where Emp_status = 'Present' and emp_id = 1

this return me 0 always even though there is an employee with emp_id = 1
and emp_status = 'Present' and date = '2-jan-2012'
why so , any help please ?

solved this problem

Internet Services

Web Development

Digital Marketing

Consumer Tech