Smart technology post tip's and trick
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment