这是我从查询中得到的结果

SELECT designation, location, COUNT(*) 
  FROM emp_details 
  where location != "HEAD OFFICE" 
  GROUP BY designation, location

输出

Designation Location    Count
ACCOUNTANT  Umm Al Naar 1
ACCOUNTANT-BRANCH   Ajman   1
ACCOUNTANT-BRANCH   Al Qusais   1
ACCOUNTANT-BRANCH   Dubai   1
ACCOUNTS ASSISTANT -BRANCH  Ajman   1
ACCOUNTS ASSISTANT -BRANCH  Al Ain  1
ACCOUNTS ASSISTANT -BRANCH  AL AWEER    1
ACCOUNTS ASSISTANT -BRANCH  Al Khail    1
ACCOUNTS ASSISTANT -BRANCH  Al Qusais   1
ACCOUNTS ASSISTANT -BRANCH  Fujairah    1
ACCOUNTS ASSISTANT -BRANCH  Mina    1
ACCOUNTS ASSISTANT -BRANCH  Mussafah 1  1
ACCOUNTS ASSISTANT -BRANCH  RAS AL KHAIMA   1
ACCOUNTS ASSISTANT -BRANCH  Sharjah 1
BRANCH IN CHARGE    Beda Zayed  1
BRANCH IN CHARGE    Fujairah    1
BRANCH IN CHARGE    Mina    1
BRANCH IN CHARGE    Mussafah 2  1
BRANCH IN CHARGE    Sharjah 2   1
BRANCH MANAGER  Ajman   1
BRANCH MANAGER  Al Ain  1
BRANCH MANAGER  AL AWEER    1
BRANCH MANAGER  Al Khail    1
BRANCH MANAGER  Al Qusais   1
BRANCH MANAGER  Dubai   1
BRANCH MANAGER  Mussafah 1  1
BRANCH MANAGER  NEW YORK    1
BRANCH MANAGER  RAS AL KHAIMA   1
BRANCH MANAGER  Sharjah 1
COUNTER SALES   Ajman   4
COUNTER SALES   Ajman 2 1
COUNTER SALES   Al Ain  3

但我想

Branch    ACCOUNTANT     ACCOUNTANT-BRANCH ACCOUNTS ASSISTANT....
Ajman      3             4                  1       
Mussafah    5            2                  2