sqllite - sql question 101
Posted
by qstar
on Stack Overflow
See other posts from Stack Overflow
or by qstar
Published on 2010-03-14T14:18:18Z
Indexed on
2010/03/14
14:25 UTC
Read the original article
Hit count: 371
Hi,
I would do something like this*
- select * from cars_table where body not equal to null.
- select * from cars_table where values not equal to null And id = "3"
I know the syntax for 'not equal' is <>, but i get an empty results.
For the second part, I want to get a result set where it only returns the columns that have a value. So, if the value is null, then don't include that column.
Thanks
© Stack Overflow or respective owner