ruilog
Notebook
Blog
About
Content Explore
1.12 将空值替换为实际值
Published : 2008-11-13
Categories :
Cookbook
Tags :
SQL
DB2
MySQL
Oracle
PostgreSQL
Database
MSSQL
COALESCE
Q: 用非空值替换空值
A: 使用 COALESCE
Oracle,MySQL,PostgreSQL,MSSQL,DB2 (使用COALESCE())
SELECT coalesce(comm, 0)...
1
Categories
All
Database and Storage
NoSQL
Storage
Graph
SQL
Research and Development
Algorithms
Machine Learning
NLP
Intelligent Transport System
Information Retrieval
Coding
Big data
Message Queue
Security
Tips
Network
Design
OS
Archives
Others
Hardware
Web Design
Software
Web Develop