SQL: all 运算符 可以 表示 非空(NOT NULL)的意思吗?

 

 

 

select count(all grade) from customer;

 

SELECT COUNT(DISTINCT customer_id) FROM customer WHERE grade IS NOT NULL;

posted @ 2019-07-12 10:32  jimy1  阅读(525)  评论(0编辑  收藏  举报
Total Visits
AmazingCounters.com