数据库转化null值_MySQL
- WBOYOriginal
- 2016-06-01 13:51:16774browse
mysql数据库:
SELECT<br> IF(AVG(cai.conversionsRate) IS NULL,0,AVG(cai.conversionsRate))<br> AS conversionsRate<br> FROM campaign_info cai<br> WHERE insertTime BETWEEN '2011-02-01' AND '2011-02-04' AND googleCampaignId=23331401
Ms-SqlServer数据库
/*MS-SqlServer去除NULL值*/<br> select ISNULL(avg(cai.conversionsRate),0)<br> AS conversionsRate<br> FROM campaign_info cai<br> WHERE insertTime BETWEEN '2010-02-11' AND '2011-01-23' AND googleCampaignId=42722951
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL修改root密码_MySQLNext article：MySQL的一些技巧_MySQL