How to display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000?
Select employeename from employee where(job=’clerk’ or job=’salesman’ or job= ‘Analyst’) and salary>3000;
Or
Select employeename from employee where job in(‘clerk’,’slaesman’,’analyst’) and salary>3000;
How to display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000 in Oracle?
Do i need to write in PL/SQL or is it possible in SQL query?