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)...
Categories
All
Database and Storage NoSQL Storage Graph SQL
Research and Development Algorithms NLP Machine Learning Information Retrieval Intelligent Transport System Coding Message Queue Big data Security Tips Network OS Design
Archives Others Hardware Web Design Software Web Develop