Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
self join - SQL
--Sql Server 2014 Express Edition --Batches are separated by 'go' CREATE TABLE EMPLOYEES(ID INT IDENTITY PRIMARY KEY, NAME VARCHAR(50), MANAGER_ID INT REFERENCES EMPLOYEES(ID)) GO INSERT INTO EMPLOYEES VALUES('John', 1), ('Peter', 1), ('Adam', NULL), ('James',2), ('Micheal',1) go SELECT * FROM EMPLOYEES GO SELECT E.NAME AS MANAGER, M.NAME EMP_NAME FROM EMPLOYEES E INNER JOIN EMPLOYEES M ON E.ID = M.MANAGER_ID
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
identity
3r3r
employee table
Except Insert missing
Me
emp 4
Task_3_FInal
count events by 2 shift cycles using CTE
Task_6_Final
aaa
stackse - search stackoverflow differently
Please log in to post a comment.