Hi Everyone,
Thanks for your time.

I have a question about COUNT in sql. Does anyone know how to display the COUNT if it is equal to 0?

Please feel free to ask me any question if you don't understand my enquire.

Thanks for the post.

6 Years
Discussion Span
Last Post by ChrisPadgham
select last_name, count(*) total from user_master 
group by last_name
having count(*) = 1

This query will find last_name that occurs only once in the table.
so you must use having with aggregate functions.

Edited by urtrivedi: n/a


The difficulty is that count() works against summarising existing rows in a table. By definition a count of 0 means that no rows exist so nothing will appear. How would SQL know what the missing values were. To address the problem you will need to set up a reference table with all the valid values in it and do an outer join against the table with the data in it.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.