MySQL基础_单行函数练习

练习

# 显示系统的时间
SELECT NOW();

# 查询员工 姓名 工资 以及工资提高百分之20%之后的结果
# 1.2 工资本身 在加上 0.2 结果
SELECT last_name,salary, salary * 1.2 AS towResult   FROM employees

# 将员工的姓名按首字母排序 并写出姓名的长度(length)
# 默认asc  SUBSTRING() 截取出首字母
SELECT last_name  ,LENGTH(last_name) na FROM employees ORDER BY SUBSTRING(last_name,1,1)  

# 输出格式King earns 24000 monthly but wants 7200 
SELECT
	CONCAT(
	REPLACE ( last_name, '_', '' ),
	' ',
	'earns',
	'  ',
	TRUNCATE ( salary, 0 ),
	' ',
	'monthly',
	' ',
	'but',
	' ',
	'wants',
	' ',
	TRUNCATE ( salary * 3, 0 ) 
	) AS 'Dream Salary' 
FROM
	employees

# 查询员工 职位 分等级
SELECT
	last_name,
	job_id,
CASE
	job_id 
	WHEN 'AD_PRES' THEN
	'A' 
	WHEN 'ST_MAN' THEN
	'B' 
	WHEN 'IT_PROG' THEN
	'C' 
	WHEN 'SA_REP' THEN
	'D' 
	WHEN 'ST_CLERK' THEN
	'E' 
	ELSE 'F'
	END AS Grade 
FROM
	employees;

内容有错误 观看请持有怀疑态度