Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    47

    Unanswered: count() returns me 0 always

    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 ?

  2. #2
    Join Date
    Sep 2011
    Posts
    47

    solved

    Quote Originally Posted by navedjobs View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •