Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
find count of employees with salary more 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 -- find count of employees with salary more than thier managers
run
|
edit
|
history
|
help
0
Exam_1_Final
Fff
Demo
MERGE WITH OUTPUT
DBMS ca2
subquery & correlated subquery & "is null" condition
Libros
Exam_1
TestTable
SQL Server NULL replacement with dynamic value