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: 369

Filed under:
|

Hi,

I would do something like this*

  1. select * from cars_table where body not equal to null.
  2. 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

Related posts about sql

Related posts about sqllite