Re: [SQL] strange result for select * from table where id=random()*900

2007-07-27 Thread Kristo Kaiv
On 27.07.2007, at 10:48, Stefan Zweig wrote: hi list, this is my query: select * from _g2977 where id=floor(random() * (900)); in table _g2977 i have id(s) from 1 up to 900. i just want to select one random dataset by the above query but i does not work. actually i get sometime zero, som

Re: [SQL] strange result for select * from table where id=random()*900

2007-07-27 Thread Achilleas Mantzios
Στις Παρασκευή 27 Ιούλιος 2007 10:48, ο/η Stefan Zweig έγραψε: > hi list, > > this is my query: > > select > * > from _g2977 > where > id=floor(random() * (900)); > > in table _g2977 i have id(s) from 1 up to 900. i just want to select one > random dataset by the above query but i does not work. >

Re: [SQL] strange result for select * from table where id=random()*900

2007-07-27 Thread Tommy Gildseth
On 07/27/2007 09:48 AM, Stefan Zweig wrote: hi list, this is my query: select * from _g2977 where id=floor(random() * (900)); in table _g2977 i have id(s) from 1 up to 900. i just want to select one random dataset by the above query but i does not work. actually i get sometime zero, some

[SQL] strange result for select * from table where id=random()*900

2007-07-27 Thread Stefan Zweig
hi list, this is my query: select * from _g2977 where id=floor(random() * (900)); in table _g2977 i have id(s) from 1 up to 900. i just want to select one random dataset by the above query but i does not work. actually i get sometime zero, sometimes one, sometimes two and sometimes even th