Thread: SQL query

Select common job from dept 10, 20,30.
Default Table emp and dept

can you please specify exactly what is the output you are expecting.
so that i can suggest you accordingly.

you can try this

Code:

select distinct(job) from emp where deptno in(10,20,30);

hi ppl this is praveen... its really good to get doubts cleared by online.. thanks to geeks talk