Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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.
Delete cascade
Ranking
performance on update using subquery versus correlated update
parameters_in_procedure-join&correlated sub-query content
Libros
get inused indexes
Hierarchy table to exclude root
tp3
FIGURA5.2
robot-grading
Please log in to post a comment.