[sqlite] How to get 1 row with no null columns

[Simon Slavin]

On 11 May 2016, at 11:26am, William Drago <wdrago at verizon.net> wrote:

> Is there a simple way to find a row in a table where none of columns contain 
> a null value? For example:
> 
> SELECT * FROM AnyTable WHERE (all columns IS NOT NULL) LIMIT 1;

The coalesce(a,b,c, ...) function returns the first of its arguments which 
isn't NULL.  If they're all NULL it returns NULL.  So it sort-of does what you 
want, but you will have to list the column names.

Simon.