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. I can do somthing like: SELECT * FROM (SELECT a FROM v WHERE a IS NOT NULL LIMIT 1), (SELECT b FROM v WHERE b IS NOT NULL LIMIT 1), (SELECT c FROM v WHERE c IS NOT NULL LIMIT 1), (SELECT d FROM v WHERE d IS NOT NULL LIMIT 1), (SELECT e FROM v WHERE e IS NOT NULL LIMIT 1); to get 1|5|2|4|9. But is there a more convenient way? I don't think I can define an aggregate function (similar to coalesce) since the order will not be defined. But perhaps I'm missing the obvious solution. -- Steinar Midtskogen _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users