You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by Sidra shah <s....@gmail.com> on 2017/02/07 14:42:14 UTC

OFFSET

Hello, I have ten questions and want to display questions from 3-6 first
and the rest after that. Is it possible through Order by and Offset keyword?

Regards

Re: OFFSET

Posted by "Lorenz B." <bu...@informatik.uni-leipzig.de>.
I don't understand why you're making things always so complicated.
OFFSET n skips the first n results, thus, you wouldn't have access to
those anymore.

Do it in your application code and not with SPARQL.

> Thank you Andy, I want to display all questions but from 3-6 first. I have
> read about OFFSET that it will only display in the range and skip the rest.
> If it is the case, can we avoid the skip of questions?
>
> Regards
>
> On Tue, Feb 7, 2017 at 8:11 PM, Andy Seaborne <an...@apache.org> wrote:
>
>> Yes.
>>
>> Try it.  Don't forget to sort.
>>
>>     Andy
>>
>>
>> On 07/02/17 14:42, Sidra shah wrote:
>>
>>> Hello, I have ten questions and want to display questions from 3-6 first
>>> and the rest after that. Is it possible through Order by and Offset
>>> keyword?
>>>
>>> Regards
>>>
>>>
-- 
Lorenz B�hmann
AKSW group, University of Leipzig
Group: http://aksw.org - semantic web research center


Re: OFFSET

Posted by Sidra shah <s....@gmail.com>.
Thank you Andy, I want to display all questions but from 3-6 first. I have
read about OFFSET that it will only display in the range and skip the rest.
If it is the case, can we avoid the skip of questions?

Regards

On Tue, Feb 7, 2017 at 8:11 PM, Andy Seaborne <an...@apache.org> wrote:

> Yes.
>
> Try it.  Don't forget to sort.
>
>     Andy
>
>
> On 07/02/17 14:42, Sidra shah wrote:
>
>> Hello, I have ten questions and want to display questions from 3-6 first
>> and the rest after that. Is it possible through Order by and Offset
>> keyword?
>>
>> Regards
>>
>>

Re: OFFSET

Posted by Andy Seaborne <an...@apache.org>.
Yes.

Try it.  Don't forget to sort.

     Andy

On 07/02/17 14:42, Sidra shah wrote:
> Hello, I have ten questions and want to display questions from 3-6 first
> and the rest after that. Is it possible through Order by and Offset keyword?
>
> Regards
>