Re: Random Query

Posted in 2000

Paul Watson — Fri, 07 Jan 2000 09:13:32 +0000 — source: Informix-list mailing list archive (1991-1998)

In pure SQL no, but you could do it in SPL, check out iiug.org for random number SPL > > 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 -- Paul Watson # WF Software # If it was easy Tel ++44 1436 674729 # Everybody could do it Fax ++44 1436 678693 # www.wfsoftware.com/informix #