Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sql random query
- Thread starter rushie84
- Start date
Cagliostro
Programmer
what database are you using?
Ion Filipski
ICQ: 95034075
AIM: IonFilipski
filipski@excite.com
Ion Filipski
ICQ: 95034075
AIM: IonFilipski
filipski@excite.com
- Thread starter
- #3
Cagliostro
Programmer
you could solev your problem if you add an integr random number colum to your table like this
alter yourtable add column(yourRndColumn integer)
update yourtable set yourRndColumn = Rnd() * 20
the last step
select * from yourtable
where yourRndColumn = 1
instead of 1 you could also put a any other random numbers.
so you will select randomly 5% of
Ion Filipski
ICQ: 95034075
AIM: IonFilipski
filipski@excite.com
alter yourtable add column(yourRndColumn integer)
update yourtable set yourRndColumn = Rnd() * 20
the last step
select * from yourtable
where yourRndColumn = 1
instead of 1 you could also put a any other random numbers.
so you will select randomly 5% of
Ion Filipski
ICQ: 95034075
AIM: IonFilipski
filipski@excite.com
- Status
Similar threads
- Locked
- Question