HANA SQL分组后取第一行数据

场景：需要获取每一类产品中第一行的数据。写法如下

select * from (
	SELECT 
		"BDATE",
		"PRODUCT",
		"AREA",
		"PRICE", 
		ROW_NUMBER() over (partition by "PRODUCT" ORDER BY "PRODUCT","AREA") AS RN
	FROM "INPUT_MAR_PRODUCTPRICE"
	where bdate = '2021-08-19'
	order by "PRODUCT",	"AREA"
)
where RN=1