Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Select empID whose salary is greater than their managers
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' --empID, salary mgrID --1, 100, 4 --2, 120, 6 --3, 110, 4 --4, 200, 6 --5, 120, 4 --6, 150, 7 --7, 200, NULL -- Select empID whose salary is greater than their managers
run
|
edit
|
history
|
help
0
Microsoft SQL Server in 10 mn - Lesson 14 Joining Tables samples...
count events by 2 shift cycles using CTE
28-02
MyShopSchema
Trim numbers
ss
StackOverflow_53575163
ms sql where ,like
SS my sql server 2014 4/7
Task_3_Final