Hi,

You wrote it :)
But this is supported by fb2

Try order by random()

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "Luiz" <cprmlao@...>
Do: <firebird-support@yahoogroups.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]