ansaurus

Question

Answer 1

+1 A:

Do you mean this?

select status, count(*)
from   employees
group by status

Or

select name, count(*)
from   employees
where status = 'Present'
group by name

JohnoBoy 2010-09-20 09:50:09

if i have a name abc in database for that name how can i get the count

sumithra 2010-09-20 09:56:43

just add to the `WHERE` clause your name, like `WHERE name = 'abc'`

balexandre 2010-09-20 10:04:53

Answer 2

A:

Select count(*) from employees where status="Present" group by name;

explorex 2010-09-20 09:50:12

I have a name abc in my database. Everytime he checkins status l be set present. Now i need to get the count of status only for abc.

sumithra 2010-09-20 09:58:52

select count(name), name from employees where status='Present' and name='abc';

explorex 2010-09-21 05:51:59

Answer 3

A:

select count(1) from employees where status='Present' group by name

2010-09-20 09:52:24

Answer 4

A:

Try this:

select name, count(*)
  from employees
  where name = 'abc' and
        status = 'Present';

Share and enjoy.

Bob Jarvis 2010-09-20 11:45:54

How to write nested query?