Sharepoint List - Loading only max report ID

Hi 
I have a simple sharepoint list with a reporting ID ( Integer Type) which tells me the latest reporting period. 
The list had multiple reporting IDs, I need to load data with only the latest reporting period. 

I know in SQL its easy to do,:

Select * from table

Where ReportingID = (Select Max(RepPeriodID) from table1)

But not sure how to do in Sharepoint lists

Any help will be appreciated.