Posts by Joao Victor Santi • 11 points

• 1

  votes

  1

  answer

  53

  views

  A: Turn rows into columns in SELECT Oracle

  With PIVOT you solve this. Example : SELECT d.department_name, e.job_id, count(e.employee_id) FROM hr.employees e INNER JOIN hr.departments d ON d.department_id = e.department_id GROUP BY…

  sql oracle select

  answered 3 years, 8 months ago Joao Victor Santi 11