How to write nested query?

Question

I need to display the count of present status for a particular name

Select count(*) from employees where status='Present';

This query returns me entire present count. What should I do to get status for a particular name?

for the question you ask to all the comments in all answers, you should start to see some SQL tutorials, try this first: w3schools.com/sql/default.asp - Ahhh, and keep in mind that SQL is not Microsoft SQL, SQL is a database query language! — balexandre
– balexandre, Commented Sep 20, 2010 at 10:06

JohnoBoy · Accepted Answer · 2010-09-20 09:50:09Z

2

Do you mean this?

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

Or

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

answered Sep 20, 2010 at 9:50

JohnoBoy

5651 gold badge7 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

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

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

Bob Jarvis - Слава Україні · Accepted Answer · 2010-09-20 11:45:54Z

0

Try this:

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

Share and enjoy.

answered Sep 20, 2010 at 11:45

50.2k10 gold badges81 silver badges119 bronze badges

user435076 · Accepted Answer · 2010-09-20 09:52:24Z

-1

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

answered Sep 20, 2010 at 9:52

user435076

1