Getting UDA-SQL-0358 Line 11: Syntax error near "over". IN Framework Manager

[gosoccer]

Could someone please help, :'( :'(

Getting this error and just can't figure it out after couple hours of investigation,

This query contains an error and can not be executed.

It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0358 Line 11: Syntax error near "over".

Here is the code,
select
         REC_ID,
         JR_CD,
         STATE_CD,
         CTY_CD,
         MGR_NAME,
         EMP_NAME,
         STATUS_CD,
         cast(UPDATE_TIME AS DATE) Update_Date,   
                        CR_DT_ID,   
         rownumber() over (partition by REC_ID order by Update_Date desc) caserank
      from
         RESOURCE.RES_FACT
      order by
         REC_ID

I even changed the UPDATE_TIME to just date and not date stamp as it is shown as Time Data Type in the
database.

Thanks so much. ;D ;D

[gosoccer]

I meant to say, "not date and Time Stamp but just Date. The DataType is Time at the DB level.
I'm not sure if that's causing the Over error.

Thanks