Subject | select in random order - HELP |
---|---|
Author | Luiz |
Post date | 2013-02-21T13:51:54Z |
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
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