Question: please answer quick using hr.employees from oracle live sql 1. Write a query to display the name ( first name and last name ) for
please answer quick
using hr.employees from oracle live sql
1. Write a query to display the name ( first name and last name ) for those employees who gets more salary than the employee whose ID is 100.
Sample table: hr.employees
2. Write a query to display the name ( first name and last name ), salary, department id, job id for those employees who works in the same designation as the employee works whose id is 161.
Sample table: hr.employees
3. Write a query to display the name (first name and last name ), salary, department id for those employees who earn such amount of salary which is the smallest salary of any of the departments.
Sample table: hr.employees
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
