Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

找出高於自己(id=108)部門平均工資的員工資訊
*************************************
select employee_id,first_name,salary from emp where salary>(
select avg(salary) from emp where department_id=(select department_id from emp where employee_id=108));

找出高於自己部門平均工資的員工資訊
*************************************
select employee_id,salary from emp a1 join (select round(avg(salary)) sal,department_id from emp group by department_id)a2
on a1.department_id=a2.department_id where a1.salary>a2.sal;

以首字大寫的方式顯是員工姓名

****************************

select upper(name) from emp;

select lower(substr(name,2,lengh(name)-1) from emp;

合併

select upper(name)||lower(substr(name,2,lengh(name)-1)   from emp;