Skip to main content

Return to Question

Title and question cleanup
Source Link
peSHIr
peSHIr
  • 6.4k
  • 1
  • 36
  • 46

how How to write nested query  ?

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?

how to write nested query  

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

How to write nested query?

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?

added 9 characters in body
Source Link
Kobi
Kobi
  • 138.5k
  • 41
  • 259
  • 302

I need to display the count of present status for a particular name Select count(*) from employees where status='Present';

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

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

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

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

Source Link
sumithra
sumithra
  • 1

how to write nested query

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