Hello, I would like to use the following constraints at the end of some queries:
SELECT a FROM B WHERE c = 'toto' ORDER BY RANDOM() LIMIT 10; It is supposed to return 10 values randomly from the B table. In fact I use that with postgresql. Also if someone knows if ejbql supports a random() like operator in the order by (I could not find it anywhere). Thanks in advance, any help much appreciated. Ludovic -- View this message in context: http://www.nabble.com/limit%2C-offset-and-random-tp16547686p16547686.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
