Sql count fields not null

Another approach to select and group by month would be to concatenate month with year, like this concat month registDate , '-', date registDate.

But it's less elegant. The case operator proposed in other responses is perfectly valid, but I think it more adequate for other situations. And it's more verbose. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Count null and not null values in a column Ask Question.

Asked 7 years, 8 months ago. Active 5 years, 10 months ago. Viewed 55k times. I googled it and can not find a definition. Could someone provide a clue for me as to what this means? K Khaled. K 5, 1 1 gold badge 31 31 silver badges 49 49 bronze badges. ID, b. Mayank Mayank 1, 5 5 gold badges 21 21 silver badges 37 37 bronze badges. Similary, but dynamically: drop table if exists myschema. Mark Andrew Mark Andrew 78 6 6 bronze badges. Pedro Pinheiro Pedro Pinheiro 12 12 silver badges 30 30 bronze badges.

Luis Casillas Luis Casillas 29k 5 5 gold badges 48 48 silver badges 99 99 bronze badges. This won't work. If a,b,c aren't numeric it will raise an error. If they are numeric it will return the wrong results.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked 3. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Which aggregate function accepts null values? Aggregate function results with different column states. How do I count null values in postgresql? Do group functions ignore null values? How do I find duplicates in SQL? How it works:. Can you count distinct in SQL?

How do I query a date in SQL? What is not like SQL? What is the difference between count and count distinct? Similar Asks. Popular Asks.