要求在SQL中获取最新更新的记录

For the below data, I need to fetch the records with latest revision. In the below given data I have two rows with Doc# 5 with Item# 048 and Revision 0 and 1 respectively. My requirement is to fetch the all the records with the max revision. @nd example is doc#17 where there are three revisions available 0,1, and 2 but the requirement is to get the latest revision 2.For the below data, I need to fetch the records