gistfile1.txt

SQL> select count(*) a, trim(oachid) from oohead where oaadid='ÚÚÚÚÚÚ' and oaordt like '2014%' group by trim(oachid) order by a desc
+------------+-----------+
| A          | 00002     |
+------------+-----------+
| 175        | FACTURELV |
| 93         | MANDRE    |
| 53         | AHONCZARUK|
| 40         | SMORAND   |
| 20         | SVALCROZE |
| 19         | AIVARS    |
| 7          | NPONCET   |
| 6          | CBRIONE   |
| 5          | CMLEXPLOIT|
| 5          | DMILLET   |
| 5          | JSAUSSE   |
| 4          | VNGUYEN   |
| 3          | NDESCHAMP |
| 3          | ACARVALHO |
| 3          | PROUSSEZ  |
| 1          | JCHARRETON|
| 1          | JGEROLAMI |
| 1          | JPFOUQUET |
| 1          | BDEMOULIN |
| 1          | BCHAPPEY  |
| 1          | FVERNEZ   |
| 1          | STHEVENET |
+------------+-----------+