Comment by billwashere

select distinct customer_id, max(order_id) over (partition by customer_id order by created_date desc) FROM orders

http://sqlfiddle.com/#!15/51df39/2