Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Solution 3
/* Problem: Write a SQL statement to list all employees that are not managers. Add your solution at the end. Expected Output: EmployeeId FirstName LastName 3 Mason Farrell 8 Isabella Portman 9 Ethan Firth 10 Emily Theron */ -- Create a table called Employees CREATE TABLE Employees ( EmployeeId INT PRIMARY KEY, FirstName VARCHAR(200), LastName VARCHAR(200), ManagerEmployeeId INT) GO -- Fill Employee table INSERT INTO Employees VALUES(1, 'Noah', 'Clooney', NULL) INSERT INTO Employees VALUES(2, 'Liam', 'Brolin', 1) INSERT INTO Employees VALUES(3, 'Mason', 'Farrell', 1) INSERT INTO Employees VALUES(4, 'Emma', 'Jolie', 1) INSERT INTO Employees VALUES(5, 'Jacob', 'Foxx', 2) INSERT INTO Employees VALUES(6, 'William', 'Damon', 4) INSERT INTO Employees VALUES(7, 'Olivia', 'Johansson', 5) INSERT INTO Employees VALUES(8, 'Isabella', 'Portman', 1) INSERT INTO Employees VALUES(9, 'Ethan', 'Firth', 6) INSERT INTO Employees VALUES(10, 'Emily', 'Theron', 7) GO ------------------------------------------------------------------ -- Sql Server 2014 Express Edition - 12.0.2000.8 -- Solution. ------------------------------------------------------------------ SELECT EmployeeId, FirstName, LastName FROM Employees WHERE NOT EmployeeId IN (SELECT DISTINCT ManagerEmployeeId FROM Employees WHERE ManagerEmployeeId IS NOT NULL )
run
|
edit
|
history
|
help
0
Calculation of a status life duration
Sum then delete one row - SQL Server 2008 R2
QLDT TUAN 6
identity
FIGURA5.2
SQL Stringdata
Rno 37 boat
SQL Server - NULL values with IN and NOT IN
Lisber-SQL-Example(CASE)
20181cse0012dbmsca2