Le 12:26 11/05/2016, vous avez ?crit: >All, > >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;
select * from AnyTable col1||col2||...||coln is not nul limit 1; Fine for SQLite but could fail in other RDBMS, in which numeric columns must be converted into characters: ...||cast(colj as char)|| ... I see no way to write a generic, table-independent, query unless it is generated from the metadata of the table. J-L Hainaut
