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.

enter image description here

I want the output of the above table as follows:

enter image description here

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.

  • what MySQL version?
    – danblack
    Nov 19 '18 at 7:34
  • @danblack, MySQL version is 5.7. Nov 19 '18 at 7:46
  • See the tag I added.
    – Rick James
    Nov 20 '18 at 3:09
  • @RickJames, Yes Rick ,I have missed to add that tag. Thanks for notify and it's accepted. Nov 20 '18 at 4:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.