How to get the latest LastUpdate ,LocReqNo of each locationID of MySQL queryautoricardo.ch - Fahrzeugmarkt – Apps bei Google Play

Asked Nov 19 '18 at 06:59

Active Nov 20 '18 at 10:37

Viewed 29 times

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.

edited Nov 20 '18 at 10:37

Community

asked Nov 19 '18 at 06:59

0 Answers0