APEX

Hi,

Is there any way to use a control break on Dept column in a SQL query to have a Output-2 instead of Output-1.
Is there any way to modify the SQL query.

SQL

select dept, loc, count(*)
  from dept
group by dept, loc

Output-1

  Dept      Loc       Count(*)
  10         AA        1
  10         BB        2
  10         CC        2
  20         AA        2
  20         BB        2

Output-2

  Dept      Loc       Count(*)
  10         AA        1
             BB        2
             CC        2
  20         AA        2
             BB        2

Thanks,
Deepak