null values in sql

Question

i have data like this

ID Nu name 1 234 asd 2 566 asd 3 - sdf 4 356 sd 5 NULL sfsg

now how to get all data with - and null values

NULL is not a value - it's the absence of a value .... — marc_s
– marc_s, Commented Dec 2, 2016 at 7:39

Ratan Phayade · Accepted Answer · 2016-12-02 07:47:24Z

select * from table_name;

this will give you all the data with - and null value

if you want to fetch only the data where nu is null and - use this:

select * from table_name where nu is null or nu = '-';

I think this should help.

Danyal Sandeelo · Accepted Answer · 2016-12-02 08:04:28Z

0

select * from table_name where Nu is null or Nu='-'

answered Dec 2, 2016 at 8:04

12.4k10 gold badges57 silver badges90 bronze badges

Comments

Nahuel Ianni · Accepted Answer · 2016-12-02 10:05:39Z

To get all the info from the table you can use the following query:

select * from table_name;

To filter by null and dash values, try the where clause:

select * from table_name where nu is null; UNION ALL select * from table_name where nu = '-';