problems with picking up the latest record..

Hi,
I have a table in my database which has a date column...I need to pick up a resultset based on a where clause, identify the latest record based on the date column and then go ahead and pick up other values of the latest record. Here is the rough structure of the query..How could we use max with a date??..or could we do an order by...desc and pick up the first record??..Please help..

select bill_nbr from bill_table
where (bill_date is the most recent.)

Thanks in Advance.
Deepu.

-- 
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Oracle-problems-picking-latest-record-ftopict255289.html
Visit Topic URL to contact author (reg. req'd).  Report abuse: http://www.dbforumz.com/eform.php?p=881189