基本操作:
SELECT last_name FROM employees;
SELECT last_name,salary,email FROM employees;
SELECT `first_name`,`last_name`,`email`,`phone_number` FROM employees;
SELECT 'john';
SELECT '100'+123;
SELECT CONCAT(first_name,last_name) AS 结果 FROM employees;
SELECT DISTINCT `job_id` FROM employees;
SELECT
IFNULL(commission_pct,0) AS 奖金率,
commission_pct
FROM employees;
SELECT
CONCAT(`first_name`,',',`last_name`,',',IFNULL(commission_pct,0)) AS out_put
FROM employees;