Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Select ve.Branch,count(ve.ID) 'No of Available Employees ' from [126.96.36.199].HumanResources.dbo.vwEmployee ve left join [188.8.131.52].HumanResources.dbo.vwBranch vb on ve.branch=vb.Name where ve.leavingdate is null group by ve.branch order by ve.Branch Select D.Branch,D.Employees 'No of Registered Employees' from (select A.Branch,count(A.EmployeeID)'Employees' from (select E.EmployeeID,E.Firstname,E.Lastname,B.Branch from dbo.tblEmployee E left join dbo.tblBranch B on E.BranchID=B.BranchID left join [184.108.40.206].HumanResources.dbo.vwEmployee VE on E.EmployeeID =VE.ID where VE.LeavingDate is null )A group by A.Branch )D order by D.Branch
|Truncate vs Delete||63||87|
|Oracle SQL Select within a Where Clause||9||38|
|how to extract a number from a MS SQL server string.||39||63|
|How to order Highest and lowest value rows alternatively in SQL Server ?||4||24|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!