i have canceled the delete statement while it is running, soon after my database showing IN RECOVERY, how to get it normal status with out affecting database files ...

i have canceled the delete statement while it is running, soon after my database showing IN RECOVERY, how to get it normal status with out affecting database files...

Terminal Loadnum FOH ROH Date 60 1 38 48 20111001 60 1 38 48 20111001 60 1 38 48 20111001 60 1 38 48 20111001 ...

Terminal Loadnum FOH ROH Date 60 1 38 48 20111001 60 1 38 48 20111001 60 1 38 48 20111001 60 1 38 48 2...

Thank You very much sir, it's really working fine....

sorry, actually the dates are 20111001 and 20111002, please replace the dates with 20111001 and 20111002, i did wrongly typed...

sure, below is the output that should come, this output is based on the sample data provided to you Terminal Loadnum Distance Date 60 1 0 20111004 60 2 150 20111004 ...

no sir,same result is coming as max(distance) takes the whole table max(distance), any other way...

Thank you for reply. but above query gives the total table2 max distance. but i need Loadnum, date wise Loadnum Date 1 20111004 1 20111004 1 20111004 2 20111004 2 20111004 2 20111004 1 20111005 1 20...

Thank you for reply. but above query gives the total table2 max distance. but i need Loadnum, date wise Loadnum Date 1 20111004 1 20111004 1 20111004 2 20111004 2 20111004 2 201...