On 19 Oct 2012, at 12:06pm, Steinar Midtskogen <[email protected]> wrote:
> Suppose I have this table v: > > a|b|c|d|e > | |2| |9 > 1| |3| |8 > 1| |4|4|7 > |5|5|4|6 > 1|6|6| |5 > > And I would like to return the first non-NULL value of each column. Rows do not have an order. Without an ORDER BY clause SELECT can return rows in a random order if it wants. If you would like to define 'order' for me I can give you a SELECT which will find the first non-NULL value in a column, probably something like SELECT c FROM v WHERE c IS NOT NULL ORDER BY rowid LIMIT 1 Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
