Oracle - Sacar de cada linea el ultimo registro

select b.short_description, a.*

from postsale.POST_HISTORY a left join postsale.post_service b on b.service_id = a.service_id

where a.msisdn in ('3243162871',

'3004703764',

'3243859948',

'3044915076',

'3243455251',

'3243457051')

and ROWNUM <=1

order by a.create_DATE desc;

SELECT b.short_description, a.*

  FROM postsale.POST_HISTORY a

       LEFT JOIN postsale.post_service b ON b.service_id = a.service_id

       INNER JOIN (SELECT a.msisdn, MAX (a.create_DATE) last_date

                     FROM postsale.POST_HISTORY a

                    WHERE a.msisdn IN ('3243162871',

                                       '3004703764',

                                       '3243859948',

                                       '3044915076',

                                       '3243455251',

                                       '3243457051')

                   GROUP BY a.msisdn) c

          ON a.msisdn = c.msisdn AND a.create_DATE = c.last_date

 WHERE a.msisdn IN ('3243162871',

                    '3004703764',

                    '3243859948',

                    '3044915076',

                    '3243455251',

                    '3243457051')