Question: Using Sql plus Displays the First_name , salary .department_id, and job _ID of all employees whose department location _ID is 1400 . 2) Write a

Using Sql plus
Displays the First_name , salary .department_id, and job _ID of all employees whose department location _ID is 1400 .
2) Write a query that displays the employee_id and last _name of all employees who work in a department with any employee whose last name ended by e.
3) Display the last_name whose job_ ID is the same as that of employee_id 141
4) displays the employee_id, last_ name, and salary of all employees who earn more than the minimum salary. Sort the results descending order by salary.
5)Display the department_id,last_name of all who work in department_name
the second letter is e

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!