Skip to Content

ROWNUM having issue..

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded