top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

sql query of EMP table?

+1 vote
220 views

How to display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000?

posted Jun 12, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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;

answer Jun 17, 2015 by Manikandan J
Similar Questions
+3 votes

How to display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000 in Oracle?

+1 vote

Do i need to write in PL/SQL or is it possible in SQL query?

...