hello
Can any one help me in writing this query please
we have order history table where I am trying to get the next row when an order got reprocessed
order history table
orderid-orderstageid-processdate-orderinfo
1234-2-05-jun-07 11:12:34AM-reporcessed
1234-2-05-jun-07 11:12:34AM-missing part
7723-5-06-jun-07 2:02:59AM - reprocessed
7723-5-06-jun-07 2:02:59AM -wrong part
I am trying to get the row after the reprocess. they will have same orderstage_id and process date
can anyone help me in getting a query
Thanks