quote:

---

select * from emp;

---

quote:

---

select distinct deptno, ename
from emp;

---

quote:

---

select * from emp
where deptno=10;

---

quote:

---

select dname, deptno
from dept where deptno=10;

---

quote:

---

select emp.ename, dpet.dname
from emp, dept
where emp.deptno=dept.deptno;

---

quote:

---

select ename, sal, sa+300
from emp;

---

quote:

---

select ename, sal, sal+100-50, sal+100*10
from emp;

---

quote:

---

select ename, sal, (sal+100)*10
from emp;

---

quote:

---

select ename, sal, comn, sal*10+comn
from emp;

---

quote:

---

select ename, sal, sal*12, annualsalary, sal*12 as "Annual Salary"
from emp;

---

quote:

---

select ename|| ' work as '|| job as employees from emp;

---