I want to get 10 records with jQL?!!

Start
Prev
1
Next
End

thanhcon91
Topic Author
Offline
New Member

9 years 10 months ago #17971 by thanhcon91

I want to get 10 records with jQL?!! was created by thanhcon91

I want to get 10 records with jQL?!! How can do it?

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

9 years 10 months ago #17972 by jpb

Replied by jpb on topic I want to get 10 records with jQL?!!

SELECT F... SAMPLE 10

The following user(s) said Thank You: thanhcon91

Please Log in or Create an account to join the conversation.

thanhcon91
Topic Author
Offline
New Member

9 years 10 months ago #17976 by thanhcon91

Replied by thanhcon91 on topic I want to get 10 records with jQL?!!

Thank you very much,
this can make run faster?
it took the record at random or sequence?

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

9 years 10 months ago #17979 by jpb

Replied by jpb on topic I want to get 10 records with jQL?!!

As it stops after the SAMPLE nn is reached it will be much faster but
from my experience it takes the records by physical sequence (taking into account any WITH conditions) and applies any sort only on the SAMPLE.
e.g.
LIST FBNK.CUSTOMER BY @ID ONLY SAMPLE 10
@ID.......
302818
303617
304416
305215
603242
604041
611232
1000270
1001069
2003015
10 Records Listed

LIST FBNK.CUSTOMER BY @ID ONLY
@ID.......
2
3
4
5
6
7
8
9
10
11
12
13
...

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.033 seconds