It's a SQL syntax task, not a revDB one and as soon as the query will be OK, revDB will just handle it as expected.
<http://archives.postgresql.org/pgsql-general/2007-08/msg02034.php> <http://bytes.com/topic/postgresql/answers/857541-random-sample-rows> Best regards, Le 2 févr. 2011 à 21:29, Rick Harrison a écrit : > Hi there, > > I need to know the best way to get a random subset > of records without duplicates in the resulting record > set using a Postgresql database query with Livecode > on On-Rev. > > In other words, I don't want to have to get all of the > records in the database first just to be able to pick > out the 21 random records i need, as that seems rather > inefficient. Assume a couple of thousand records > in the database or more. > > Thanks for your ideas in advance! > > Rick > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.woooooooords.com www.sahores-conseil.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode