Skip to content
Advertisement

Filtering empty rows from Mysql SELECT query issue

I have a SELECT query as below:

This query gives me an output like this:

My question is, how to filter the 0 due records from due_balance and modify the query to get the rest?

Expecting result should be:

I tried it in this way, but it doesn’t work for me.

Advertisement

Answer

Use HAVING Clause or use subquery then add condition outside with WHERE clause.

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement