Table :

Brand1 model1 date1

Brand1 model2 date2

Brand1 model3 date3

Brand2 model1 date1

Brand2 model2 date2

I need to get Brand1 model3 date3

                     Brand2 model2 date2

Distinct brand with latest updated date.

to achieve this i written below  sql script which is wokring fine if I run it in Sql Developer but when run the query from pega throwing error as invalid character.

I dont see any error in th e syntax , if anyone finds please let me know.

SELECT BRANDCODE as ".Brandcode" , PXUPDATEDATE AS ".pxUpdateDateTime"  FROM 

(SELECT BRANDCODE ,BRAND,PXUPDATEDATETIME,ROW_NUMBER() OVER (PARTITION BY BRANDCODE ORDER BY PXUPDATEDATETIME DESC) AS Num

FROM {class:SCB-Data-BrandModel} WHERE STATUS='1' AND APPLICATIONTYPE='Auto' ) WHERE Num = 1;