In h2 dbms I have a table
CREATE TABLE sometable
( ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
somevalue INTEGER)
And some data
INSERT INTO sometable(somevalue)
VALUES (1), (2), (3), (4), (5);
When I SELECT somevalue FROM sometable LIMIT 1 OFFSET 2 it works. Why if I want to select random row the SELECT somevalue FROM sometable LIMIT 1 **OFFSET (RANDOM()*4) doesn't work?
Aucun commentaire:
Enregistrer un commentaire