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
NAMES CODE
BTVN_QLDT_TUAN 8
FIGURA5.1
EmployeeDetails
dbray
Rank group by
Arif Secoond Query
megha
Names
ms sql where ,like