openRDF.org - View Thread - Selecting Random Records in Sesame

Welcome Guest | Login

Forum has been closed down
This forum has been closed down due to extensive spamming activities. Please use the mailing list instead.

openRDF.org Forum » Sesame & Rio: Help » Thread: Selecting Random Records in Sesame

Thread Status: Normal
Total posts in this thread: 1

[Add To My Favorites] [Watch this Thread]

Author

This topic has been viewed 771 times and has 0 replies

Mar 14, 2010 7:18:52 AM

supdeva
Member

Joined: Jul 2, 2009
Posts: 7
Status: Offline

Selecting Random Records in Sesame

Hello all,
Is there a way to choose Random records in sesame like in mysql ?
When you say
SELECT * FROM `table` ORDER BY RAND() LIMIT 0,1;

Or

SELECT * FROM `table` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `table` ) ORDER BY id LIMIT 1;
I am using Elmo configured with sesame RDF repository. My requirement is to get 10 records randomly from a table
Thanks and regards,
Supun.

[Link]

[Show Printable Version of Thread]