As I want to retrieve the LastUpdate , LocReqNo of every location. I mean to say that in the mention table there is 3 locationId , i.e., A1,A2,A3.
I want the output of the above table as follows:
I have gone through How to get latest 2 records of each group , but unable to get my expected result.
Any suggestion or help will be appreciated.