Table: Employees Employee First Name Id Last Name Dept Hire_Date Code Credit Lim

ID: 3874022 • Letter: T

Question

Table: Employees Employee First Name Id Last Name Dept Hire_Date Code Credit Limit Phone Manager id Ext 201 202 203 204 205 206 207 208 209 210 Susan 1m Martha Ellen Hen Caro Dan Fred Paula Nancy Brown Kern Woods Owens Perkins Rose Smith Exe Sal Sh Sa Sal Act Shp Shp Mkt Sal 01-Jun-1998 16-Aug-1999 02-Feb-2004 01-Jul-2003 01-Mar-2000 nu l 01-Dec-2004 01-Apr-2003 17-Mar-1999 16-Feb-2004 $30.00 $25.00 $25.00 $15.00 $25.00 null $25.00 $30.00 $15.00 $25.00 3484 (nul1) 8722 7591201 6830 202 5286 202 null (null1) 2259 203 1752 203 3357 2974 201 Campbe11 Jacobs Hoffman 201 203 8. Write a query to display distinct department codes creditlimits AND delete all the employees who work for Shipping Department or who ave manager-id nulT.

Explanation / Answer

Query to display distinct department codes credit_limits:-

SELECT DISTINCT Dept_Code, Credit_Limits
FROM Employees;

Query to delete the employees from table who work for Shippping Department or Manager_id null:-

DELETE FROM Employees
WHERE Dept_Code='shp' OR Manager_id is NULL;

NOTE:- Please change the values of column name as per your table if required.

---------------------------------------------------------------------------------------------------------------------------------------------------------

Thank you for asking... Keep Chegging.. :)

Please give a thumbs up if u like the solution.

Navigate

Table: Employees Employee First Name Id Dept Code Credit Limit Phone Manager-id

Table: Employees Employee First Name Last_Name Dept Hire_Date Phone Manager-id $

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

Table: Employees Employee First Name Id Last Name Dept Hire_Date Code Credit Lim

Question

Explanation / Answer

Related Questions

Navigate