1,WHERE 字句紧跟 FROM 字句
2,查询last_name为‘king’ 得员工信息,注意:在‘ ’内要区分大小写
select first_name,last_name
from employees
where last_name='King'
3,查询1998-4-24来公司得员工有哪些?
注意:日期必须要放在单引号中,且必须是指定得格式
select last_name,hite_date
from employees
where hire_date='24-4月-1998'
--where to_char(hire_date,'yyyy-mm-dd')='1998-04-24'
4,查询公司工资在5000---10000之间的员工信息
select last_name,salary
from employees
--where salary>=5000 and salary <= 10000
where salary between 5000 and 10000
5,查询工资在6000,7000,8000,10000的员工
select *
from employees
--where salary=6000 or salary=7000 or salary 8000 or salary=9000 or salary=10000
where salary in(6000,7000,8000,9000,10000)
6,查询last_name中有第二个字符的所有员工信息
selest *
from employees
where last_name like '_o%'
7,查询last_name中含有‘_’字符的所有员工信息
1)准备工作
update employees
set last_name='Jones_Tom'
where employee_id=195
2)使用escape 说明转义字符
select *
from employees
where last_name like '%\_' escape '\'
8,查询commission_pct 字段的所有员工信息
select last_name,commission_pcct
from employees
where commission_pct is not null
9,ORDER BY:
1)若查询中有表达式运算,一般使用别名排序
2)按多个列排序:先按第一列排序,若第一列中有相同的,再按第二列排序
格式:order by -一级排序列 asc/desc,二级排序列 asc/desc;
select last_name,department_id,salary,12*salary annual_sal
from employees
order by annual_sal
select last_name,department_id,salary
from employees
order by salary desc,last_name asc