Hi, I have a question. Is the integrated search function in the web site working for you? On the web site http://h2database.com if I click on the field below "Search:" on the far left and type 'rand' I get a link to 'Functions'. If I click on it, I am redirected to
http://www.h2database.com/html/functions.html?highlight=RAND&search=rand#firstFound If I then click on the yellow 'RAND' I am redirected to http://www.h2database.com/html/functions.html?highlight=RAND&search=rand#rand Maybe you have disabled Javascript? If yes why? If not, what browser are you using? Regards, Thomas On Mon, Dec 29, 2008 at 4:48 AM, [email protected] <[email protected]> wrote: > > Is there a random() function in H2? I'd like to do something like the > following: > > select * from my_table order by random() limit 1 > > to get a random row from my_table. > > Thanks > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
