现要查找order_num不为NULL的所有数据,下面语句正确的是:
SELECT * FROM orders WHERE order_num != NULL;
SELECT * FROM orders WHERE order_num <> NULL;
SELECT * FROM orders WHERE order_num IS NOT NULL;
SELECT * FROM orders WHERE order_num NOT IS NULL;
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题