top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to display the names of employees in Sql Query?

+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?

posted Jun 11, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

+1 vote
select employeename from employee where department in('clerk','salesman','analyst') and salary >3000
answer Jun 11, 2015 by Shivaranjini
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.