Limit ALL not working with offset

[Sanjiv Kumar]

Hello
         I trying to use limit all with offset, but it not working.
My query:-
               select c.CategoryID  from demoPlugin.dbo.Category as c group
by c.CategoryID order by 1 desc limit ALL offset 10;

While firing this query its showing:- "No result found."

But if i remove offset 10, then it working fine.
    select c.CategoryID  from demoPlugin.dbo.Category as c group by
c.CategoryID order by 1 desc limit ALL;

What is the problem.? Is limit all is not supported with offset?


-------------------
Thanks & Regards
   Sanjiv Kumar