Hi,
Ok, thanks to all. Luiz De: [email protected] [mailto:[email protected]] Em nome de [email protected] Enviada em: quinta-feira, 21 de fevereiro de 2013 12:56 Para: [email protected] Assunto: Odp: [firebird-support] select in random order - HELP Hi, You wrote it :) But this is supported by fb2 Try order by random() Regards, Karol Bieniaszewski ----- Reply message ----- Od: "Luiz" [email protected] <mailto:cprmlao%40gmail.com> > Do: [email protected] <mailto:firebird-support%40yahoogroups.com> > 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] [Non-text portions of this message have been removed]
