Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

How to remove null from results

I have this SQL statement:

select 
    v.venue_id, v.name
from
    venues v
where 
    not exists (select e.vid
                from events e
                where e.vid = v.venue_id);

Here is the result of the query:

result of SQL statement, has venue id in one column and name in the other

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

It works fine but the last row in the result is null, how do I remove that? Been trying for a bit now with no luck

>Solution :

I think this might be what you’re experiencing
Why does SQL workbench always return a row full of null values in every query?
Looks like that’s normal behavior

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading