查询对应员工的工资
select employee_name,salary from dmhr.employee;
查询该表中所有信息
select * from dmhr.employee;
对列起别名,方便查询,别名用as代替或者可不加参考下列案例
select employee_name,salary gz from dmhr.employee;
select employee_name as mingzi,salary gz from dmhr.employee;
select employee_name mz,salary gz from dmhr.employee;
连接列 ||
“***的工资是***”
select employee_name||'的工资是:'||salary from dmhr.employee;
去重(distinct),会自动排序-升序-从小到大
查看部门编号,并且去掉重复的编号
select distinct department_id from dmhr.employee;
表达式,给每人的工资加1000块并且显示出原有工资
select employee_name,salary,salary+1000 as jgz from dmhr.employee;