Friday, May 20, 2011

Sqlite equivalent ISNULL statement

Come descritto dalle core function http://www.sqlite.org/lang_corefunc.html#ifnull l'equivalente statement รจ IFNULL.


Esempio:
SELECT ifnull(SUM(p.Pz),0) as Totale
FROM tbl_ordini p
WHERE p.Id_customer = 2

No comments:

Post a Comment