Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Select
  2. case
  3. grouping(E.LastName)
  4. when 0 then E.LastName
  5. else 'Wszystcy robole'
  6. end,
  7. case
  8. grouping(O.ShipCountry)
  9. when 0 then O.ShipCountry
  10. else 'Wszystkie kraje'
  11. end,
  12. count(O.OrderID) as 'ile'
  13. from
  14. Employees as E join Orders as O on E.EmployeeID = O.EmployeeID
  15. group by
  16. grouping sets( (E.LastName), (O.ShipCountry), (E.LastName, O.ShipCountry))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement