1)查詢員工的工資和last_name粟关，對工資進行升序排列
select salary,last_name from s_emp order by salary asc;
2)查詢員工的工資和last_name蛤袒，對last_name進行降序排列
select salary,last_name from s_emp order by salary desc;
3)查詢員工的工資和last_name卿操，
先對salary進行降序排列舶沛，再對last_name進行升序排列绩社。
select salary,last_name from s_emp order by salary desc,last_name asc;
4)請舉例說明空值的排序規(guī)則
select commission_pct from s_emp order by commission_pct;
5)查詢41號部門員工的信息强品？
select * from s_emp where dept_id = 41;
6)查詢工資大于1000的員工的信息破衔？
select salary from s_emp where salary > 1000;
7)查詢工資大于1000小于1500員工的信息辉懒，
使用兩者方式來做阳惹？
select salary from s_emp where salary between 1000 and 1500;
select salary from s_emp where salary >=1000 and salary <=1500;
8）查詢41或者42部門員工的信息，
使用兩者方式來做眶俩？
select dept_id from s_emp where dept_id = 41 or dept_id = 42;
select dept_id from s_emp where dept_id in (41,43);
9）查詢commission_pct為null的員工的信息?
select commission_pct from s_emp where commission_pct is null;
10）查詢last_name包含n的員工的信息莹汤？
select last_name from s_emp where last_name like '%n%';
11）查詢last_name包含n或者N的員工的信息？
select last_name from s_emp where last_name like '%n%' or last_name like '%N%';
12)查詢last_name第二個字母為g的員工的信息颠印？
select last_name from s_emp where last_name like '_g%';
13)查詢last_name最后一個字母為o的員工的信息纲岭？
select last_name from s_emp where last_name like '%o';
14)查詢last_name以N開頭的員工的信息？
select last_name from s_emp where last_name like 'N%';
15)先插入這條數(shù)據(jù)（注意轉(zhuǎn)義字符）
insert into s_emp(id,last_name)
values(999,'briup');
commit;
然后查詢以開頭的員工的信息线罕？
select last_name from s_emp where last_name like '\_%'escape'\';
16)找出部門41中所有經(jīng)理和部門43中的所有辦事員的詳細資料
經(jīng)理職稱為:Warehouse Manager
辦事員的職稱為:Stock Clerk
select title from s_emp where (dept_id = 41 and title = 'Warehouse Manager') or (dept_id = 43 and title = 'Stock Clerk');
17)找出部門41中所有經(jīng)理止潮、部門43中所有辦事員，
既不是經(jīng)理又不是辦事員但其薪金>=2000的所有雇員的詳細資料
select title from s_emp where (title != 'Warehouse Manager' and title != 'Stock Clerk') and salary >= 2000;
18)找出擁有提成的雇員的不同職稱
select distinct title from s_emp where commission_pct is not null;
19)找出不收取傭金或收取的傭金低于10的雇員
當傭金存在null的情況下
select last_name,nvl(commission_pct,0) from s_emp where nvl(commission_pct,0) < 10;
20)顯示不帶有'S'的雇員姓名
select last_name from s_emp where last_name not like '%S%' ;
21)顯示雇員姓名钞楼，根據(jù)其雇傭日期喇闸，將最老的雇員排在最前面
select last_name from s_emp order by start_date asc;
22)顯示所有雇員的姓名、工作和薪金询件，按工作的降序順序排序燃乍，而工作相同時按薪金升序
select last_name,title,salary from s_emp order by title desc,salary asc;
23)查詢12個月的年薪大于18000的員工的信息
select last_name,title,salary from s_emp where (salary*12) > 18000;
24)查詢13個月的年薪在10000到14000之間的員工信息
select last_name,title,salary from s_emp where (salary*13) between 10000 and 14000 ;
25)查詢41號部門工資大于1400的員工信息
select * from s_emp where dept_id = 41 and salary > 1400;
26）查詢除41,42號部門12個月的年薪大于17000員工的信息
select * from s_emp where dept_id not in (41,42) and (salary*12) > 17000;
27)查詢顧客的姓名,國家,地區(qū)區(qū)域id,并按姓名降序排序
s_customer
select name,country,region_id from s_customer order by name desc;
28)查詢顧客的姓名,國家，并按國家升序排序雳殊，所在國家相同的按姓名降序排序橘沥。
select name,country,region_id from s_customer order by country asc, name desc;
