Re: [sqlite] Random Row Selection

[Frank Baumgart]

[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Random Row Selection

[epankoke]

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?

--
Eric Pankoke
Programmer
Christian Family Software
http://www.christianfamilysoftware.com/

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]