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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
