SQLæ–‡ã§Nullã®ç½®æ›(NVL(),IsNull(),IfNull(),COALESCE()) – pg-infoSQLæ–‡ã§Nullã®ç½®æ›(NVL(),IsNull(),IfNull(),COALESCE())投稿者: ４６９６ 投稿日: 2012-09-212012-09-21 SQLServer ã§ã®Nullã®ç½®ãæ›ãˆã«ã¯ã€ŒIsNull〠SELECT IsNull(列å, '0') FROM テーブルå; Oracle ã§ã®Nullã®ç½®ãæ›ãˆã«ã¯ã€ŒNVL〠SELECT nvl(列å,'0') FROM dual; MySQL ã§ã®NUllã®ç½®ãæ›ãˆã«ã¯ã€Œifnullã€ã€ã€ŒCOALESCE〠SELECT ifnull(列å,'0') FROM テーブルå; ã¾ãŸã¯ SELECT COALESCE(列å,'0') FROM テーブルå; PostgreSQL ã§ã®Nullã®ç½®ãæ›ãˆã«ã¯ã€ŒCOALESCE〠SELECT COALESCE(列å,'0') FROM テーブルå; SQLite ã§ã®
{{#tags}}- {{label}}
{{/tags}}