Please help on SQL Query

[Pankaj Joshi]

Hello Experts, Suppose I have three fields in table named ID,Order Date and Order NO. I have to fetch the max order no along with their Id and date. actually I have more than 1000 records on a particular date. So I have to fetch max order no and max order date..... Please help

Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...

[Kishore P]

try like: select max(OrderNo), max(orderDate) from

[Pankaj Joshi]

That is not working properly. I want to know max order date first and after that what is the max order no on that particular date. Please help.:confused:

Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...

[Devan Nadar]

Hi, Use this query... select id ,ord_num, ord_Date from where ord_num = (select max(ord_num) from where ord_Date =(select max(ord_Date) from )) :)

[Pankaj Joshi]

Thank you for reply.

Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...