Random query

Posted in 2000

Francois Merle — Thu, 06 Jan 2000 11:08:03 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi there: I have a table that contains only 1 column. A list of URLs. I'd like to get a random URL that is not the one passed as argument. Is it possible to do that with SQL instead of retrieving all the records and writing a program that picks one record randomly? Francois

↪ replying to Francois Merle

Art S. Kagel — Thu, 06 Jan 2000 12:38:50 -0500 — source: Informix-list mailing list archive (1991-1998)

No. Art S. Kagel Francois Merle wrote: > > Hi there: > > I have a table that contains only 1 column. A list of URLs. > > I'd like to get a random URL that is not the one passed as argument. > > Is it possible to do that with SQL instead of retrieving all the records > and writing a program that picks one record randomly? > > Francois