SharePoint list how to show max Revision of same Document in another column

Question

I have a SharePoint list with below columns and values:

     **Doc**             **Rev**
    Doc-0001               00
    Doc-0001               01
    Doc-0001               02
    Doc-0002               00
    Doc-0002               01
    Doc-0003               00

Now I like to have another query results or view or list that shows me below result:

      **Doc**       **Rev**    **Max Rev**
       Doc-0001       00          02
       Doc-0001       01          02
       Doc-0001       02          02
       Doc-0002       00          01
       Doc-0002       01          01
       Doc-0003       00          00

I am not experienced in SharePoint am using SharePoint on promises 2013, I read something about CAML query "https://stackoverflow.com/questions/516073/max-query-using-caml" But I do not know how to use that in my sample.