sql help please

From: Pinto <reach_me_at_india.com>
Date: Wed, 31 Oct 2001 11:00:00 +0530
Message-ID: <9ro26h$nh9$1@news.mch.sbs.de>

 I have attached an sql as well as its output. it is grouped by certain  fields. i want the first row from each group having maximum count.

  SELECT agdk,

           v,
        count
             FROM
    (SELECT
                 SUBSTR(agd3.acct_group_dim_key,1,2) agdk,
     agd3.vehicle v,
     COUNT( agd3.grp_id) count
             FROM
       acct_group_dim agd3
             GROUP by agd3.vehicle, SUBSTR(agd3.acct_group_dim_key,1,2)

    ORDER BY SUBSTR(agd3.acct_group_dim_key,1,2),COUNT DESC) tmp

 AGDK V COUNT
 34 EQUITY 169
 34 null 11
 34 FIXED 10
 34 POOL 9
 34 CASH 1
 34 TEST 1
 35 EQUITY 101
 35 POOL 7
 35 FIXED 6
 35 null 6
35 CASH 1 warm regards,
Pinto. Received on Tue Oct 30 2001 - 23:30:00 CST