Subject select in random order - HELP
Author Luiz
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