Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
select emp.name, emp.department, dept.deptname, emp.manager, mgr.name, other.field, (Select trans.emp sum(case when trans.acct = 'Travel' then trans.tranamt else 0 end) as 'Travel', sum(case when trans.acct = 'Meals' then trans.tranamt else 0 end) as 'Meals', sum(case when trans.acct = 'Airfare' then trans.tranamt else 0 end) as 'Airfare' from transactions trans where trans.employee = emp.employee group by trans.emp ) from employees emp left join departments dept on emp.department = dept.department left join employees mgr on emp.manager = mgr.employee left join AnotherTable other on emp.employee = other.employee
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.