Are you sure about this query working on SQL. Because there is a syntax error. selecta.oracle_project_id, a.client_id, a.mhs_client, a.stage, a.Date_Changedfrom (select o.oracle_project_id, o.client_id, o.mhs_client, v.Date_Changed, stg.name stage,ROW_NUMBER () OVER (PARTITION BY o.oracle_project_id ORDER BY v.Date_Changed desc) AS RowNumber)from inv_investments inv ... Remove the end bracket after 'RowNumber' and try again.