Skip to Content
0

ROWNUM having issue..

Oct 16, 2017 at 12:21 AM

29

avatar image
Former Member

Hi,

I want to create an object like below query, but this is throwing error as its not having a group by function. Please advise me how to achieve this .

Basically my requirement is I want to show top 10 record based on the RVW_ERR_CT and ELE_DSC

ROW_NUMBER() OVER(PARTITION BY ERR_IDFN_TYP.REF_VAL_DSC_TXT

ORDER BY sum(IMQREAD.AGGT_IMQC_ERR_ID.RVW_ERR_CT)DESC,

((IMQREAD.IMQC_PAGE_ELE_DIM.ELE_DSC )

)rw.png

rw.png (24.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Oct 16, 2017 at 07:43 PM
0

Hi senni,

Please use bracket summing the column before order by clause and put some space between

[sum(IMQREAD.AGGT_IMQC_ERR_ID.RVW_ERR_CT)]

and DESC.

Please check and let me know.

Regards,

Anish

Share
10 |10000 characters needed characters left characters exceeded