Hi, You wrote it :) But this is supported by fb2
Try order by random() Regards, Karol Bieniaszewski ----- Reply message ----- Od: "Luiz" <[email protected]> Do: <[email protected]> Temat: [firebird-support] select in random order - HELP Data: czw., lut 21, 2013 14:51 Hi, I have a table T1(id int, name varchar(30)) Sample of data: Id name ----------------- 1 abc 2 def 10 ghi 6 lal 1000 kkk 900 LAL I´d like a select returning records in random order. Something as: Select id from t1 order by RANDOM(id) ID ----- 1 10 2 1000 900 6 Thanks in advance, Luiz [Non-text portions of this message have been removed]
