Question: 1 . Select all columns from employees table, where Last Name starts with K ( Hint: Use LIKE with % wildcard ) 2 . Select

1. Select all columns from employees table, where Last Name starts with K ( Hint: Use LIKE with % wildcard)
2. Select employee_id, first_name, last_name, salary from table employees
where salary >20000
3. Select last_name, salary
from table employees
where salary is BETWEEN 15000 AND 18000
4.Select last_name, salary, department_id
from table employees
where salary is less than 20000 AND department_id =9
5. Select last_name, job_id, department_id
from table employees
where department_id is 9 OR job_id is 9.

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 Programming Questions!