select ord_num, agent_code, ord_date, ord_amount from orders where(agent_code, ord_amount) IN (SELECT agent_code, MIN(ord_amount) FROM orders GROUP BY agent_code);
select ord_num, agent_code, ord_date, ord_amount from orders where(agent_code, ord_amount) IN (SELECT agent_code, MIN(ord_amount) FROM orders GROUP BY agent_code);