查询的方式

基础查询

1.查询常量

1. select 常量;

   	select 100; 
   

2. 显示表达式
   select 表达式;

   	select 98*23
   

3. 显示函数(方法)

   	select length('john');
   	select version();
   

4. 显示表中的字段

   	 select last_name from employees;
   

5. 显示表中的多个字段

   	select last_name,phone_number,first_name,salary,commission_pct,manager_id from employees;
   

6. 显示表中所有字段

   	select * from employees;
   

7. 起别名
   select last_name as 姓,first_name as 名 from employees;（as 可省略）

   	select last_name  "out name" from employees;
   

8. 如何去重
   select distinct 列名称 from 表名;

   	select distinct department_id from employees;
   

条件查询

• select 字段 from 表名 where 条件;

   	select last_name from employees where id > 5;
  

模糊查询

1. ’like’一般搭配着通配符使用，用作字符型的判断

   	select * from employees where last_name like '%e%';
   

2. between and

    select last_name,job_id,department_id from employees where department_id between 80 and 100;
   

3. in

   select last_name,job_id,manager_id from employees where manager_id in(100,101,110);
   

4. is null 和 is not null

   select * from employees where commission_pct is null;
   select * from employees where commission_pct is not null;
   

排序查询

select 字段|表达式|常量 from 表【where 条件】order by 排序的字段;
desc 降序，asc 升序，默认是升序

	select * from employees order by salary desc,employee_id asc;