Hi,



Ok, thanks to all.



Luiz



De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de liviuslivius@...
Enviada em: quinta-feira, 21 de fevereiro de 2013 12:56
Para: firebird-support@yahoogroups.com
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" cprmlao@... <mailto:cprmlao%40gmail.com> >
Do: firebird-support@yahoogroups.com <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]