Count of NULL and NOT NULLS

How would I write a query to count the number of instances where a the
PREP field is NULL and when it is not null. I know how to do it
seperately, can I get the numbers in the same query. I want something
like this

Project #PREP_NOTNULL #PREP_NULL

Thanks,

Jim

select concat('isnull(prep) = ' ,isnull(prep)) `condition`, count(*)
`count` from your_table group by isnull(prep)

Jim íàïèñàâ:

Quote:

How would I write a query to count the number of instances where a the
PREP field is NULL and when it is not null. I know how to do it
seperately, can I get the numbers in the same query. I want something
like this

Project #PREP_NOTNULL #PREP_NULL

Thanks,

Jim

Thanks,

Is there a way to get the counts in the same ROW

que wrote:

Quote:

select concat('isnull(prep) = ' ,isnull(prep)) `condition`, count(*)
`count` from your_table group by isnull(prep)
>
Jim íàïèñàâ:

Quote:

How would I write a query to count the number of instances where a the
PREP field is NULL and when it is not null. I know how to do it
seperately, can I get the numbers in the same query. I want something
like this

Project #PREP_NOTNULL #PREP_NULL

Thanks,

Jim

select count(*) nulls, (select count(*) from your_table where not
isnull(prep)) not_nulls from your_table where isnull(prep)

Quote:

>
Is there a way to get the counts in the same ROW
>

Count of NULL and NOT NULLS

re: Count of NULL and NOT NULLS

re: Count of NULL and NOT NULLS

re: Count of NULL and NOT NULLS

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about