top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to display the names of employees in Sql Query?

+3 votes
164 views

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 LinkedIn 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
...