- DB Assignment 2
컀미μ μ λ°μμ μλ μκ²©μ΄ λλ μ¬μμ μ΄λ¦, κΈμ¬, 컀미μ μ μΆλ ₯: select empName, job, comm from employee where comm is not null and comm<>0;
Read More
- DB Assignment 1
select e1.empname as μ¬μμ΄λ¦, e1.empno as μ¬μλ²νΈ, e2.empname as κ΄λ¦¬μμ΄λ¦, e1.mgr as κ΄λ¦¬μλ²νΈ from employee e1, employee e2 where e1.mgr = e2.empno;
Read More