SQL max() on date value with where

SELECT ord_num, ord_date, agent_codeFROM ordersWHERE ord_date=(SELECT MAX(ord_date) FROM orders);

 

200122 16-SEP-08 A004200119 16-SEP-08 A010200123 16-SEP-08 A002200135 16-SEP-08 A010