Hi,

I've an issue on query.

Above query is working correctly. If i adding offset mean i'm getting below problem.

So here i'm using offset then i got ambiguous problem. please can anyone find out what i did in wrong??. Thanks in advance...

Hi,

I would say you have on those 3 entities columns with the same name. you need to create alias for those.

Regards,

Marcelo

Marcelo Ferreira wrote:

Hi,

I would say you have on those 3 entities columns with the same name. you need to create alias for those.

Regards,

Marcelo

Hi Marcelo Ferreira,

 Thanks for your reply, i expected this may be a reason, but if i don't use offset mean that time this query has been executed successfully, so this offset expecting something on this query columns???


Hi Thanigai Arasu,

Your are Correct its issue with "OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY".

According to Oracle's documentation, If the select list contains columns with identical names and you specify the row limiting clause, then an ORA-00918 error occurs.

Solution : the only way you can avoid this by specifying alias to duplicate columns.

Hope this helps..