SELECT ename+'works like '+job AS [employee],'IN DEPARTMENT',deptno
from emp;
SELECT ename,12*SAL+ISNULL(comm,0) AS [ethsios misthos & promhteia],comm
from emp
where sal>isnull(comm,0)
order by sal DESC,ename ASC;
SELECT ename
from emp
where ename like '__R%';
SELECT ename
from emp
where job NOT LIKE 'MANAGER"';
SELECT dname
from dept
where deptno=10 OR deptno=30;
SELECT dname
from dept
where deptno in(10,30);
Select distinct job
from emp;
SELECT *
from emp
where deptno in(10,20)
order by ename DESC;
SELECT ename
from emp
where mgr in(7902,7566,7788);
Select ename
from emp
where ename like 'S%' OR ename like '____';
SELECT ename
from emp
where sal not between 1000 and 2000;
SELECT ename
from emp
where job not like 'M%';
SELECT ename,job,sal
from emp
where MGR is not null;
Select ename
from emp
where job like 'CLERK' and Sal between 100 and 2000;