本笔记为阿里云天池龙珠计划SQL训练营的学习内容,链接为:https://tianchi.aliyun.com/specials/promotion/aicampsql;
SELECT product_name, sale_price, sale_price * 2 AS "sale_price x2" FROM product;
查询两个字段以及一个新建的字段sale_price x2
SELECT product_name,purchase_price FROM product WHERE purchase_price IS NULL;
查询NULL记录
SELECT product_name,purchase_price FROM product WHERE purchase_price IS NOT NULL;
查询不为NULL的字段