[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Random Row Selection
From:       Frank Baumgart <godot () uni-paderborn ! de>
Date:       2003-12-04 23:01:36
[Download RAW message or body]

epankoke@comcast.net wrote:
> In access, I use the following statement to select a random row: "SELECT TOP 1 * \
> FROM Questions WHERE Not QuestionID IN (0) ORDER BY RND(QuestionID)".  How might I \
> accomplish this same thing in SQLite?

select * from questions ... order by random() limit 1;

Frank

---------------------------------------------------------------------
To unsubscribe, e-mail: sqlite-users-unsubscribe@sqlite.org
For additional commands, e-mail: sqlite-users-help@sqlite.org


[prev in list] [next in list] [prev in thread] [next in thread]