[sqlite] Storing Subquery Results

[Bruno Moreira Guedes]

Hello all,

I have a query where I want to reuse a subquery result. By example:

SELECT
     CASE WHEN
               (SELECT "value1") != ''
     THEN
               (SELECT "value1")
      ELSE
               (SELECT "value2")
      END;

But I don't want to repeat all the subquery again in the 'THEN'
clause. Can I store the subquery result for using it again in the same
query??

Thank you all!!

[]'s
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users