oracle sub query issue

Hi,
I am working on a project in JSP with Oracle 10G
I have a query like:
select max(item_id) itemid from item_table
in this i am getting the latest id no and the same is being displaying it back to the user.

If i want to fetch another column (suppose item_expire_date ) from same table for the max(item_id) how is it possible ?

Finally user should get his id no as well as item_expire_date for the item he has posted.

Kindly help me out please
Eagerly awaiting for response
With Thanks in advance

Naveen

re: oracle sub query issue

You need to use GROUP BY clause in the query .

re: oracle sub query issue

use this query :
hope this helps ..

re: oracle sub query issue

Hi,
Many Thankx for your idea.My problem i solved.
Regards