how to select latest or last row in a table

[alidabiri]

HI,
i have two tables: CUST and ORDERS
CUST contains:
cust_num, cust_name, cust_phone

ORDERS contains:
cust_num, order_date, order_amt

i want to list all the customers and their LATEST (LAST) order_amt.
how can i dod this?
thanks.

[DARTHTAMPON]

what database?

[alidabiri]

it doesn't matter, really, it's oracle sql.

[DARTHTAMPON]

actually it does since mssql uses "top", mysql uses "limit" and from what I can see oracle uses "rownum".

try something like this

select *
from (select * from cust order by cust_num desc)
where rownum < 2

and

select *
from (select * from ORDERS order by order_date desc)
where rownum < 2