第二章 SQL Select 语句检索数据

1. SQL的基本语法

(1) 查询有多少个唯一部门有员工在里面工作. (EMP表)

select distinct department_id from emp;

 

(2) 查询欧洲地区有多少个国家

select country_name from countries where region_id =

(select region_id from regions where region_name = 'Europe');

 

2. SQL 表达式和运算符:

(1) 两个单引号或可选的引用(q)运算符

select 'Plural''s have one quote too many' from dual;