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 28 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

what MySQL version? – danblack Nov 19 '18 at 07:34
@danblack, MySQL version is 5.7. – Md Haidar Ali Khan Nov 19 '18 at 07:46
See the tag I added. – Rick James Nov 20 '18 at 03:09
@RickJames, Yes Rick ,I have missed to add that tag. Thanks for notify and it's accepted. – Md Haidar Ali Khan Nov 20 '18 at 04:17

0 Answers0