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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
