Thursday, September 26, 2013

Query: Select Random

Ms.Access
SQL.Clear;
SQL.Add('SELECT * FROM data ORDER BY RND(INT(NOW*id)-NOW*id)');
Open;

MySql
SQL.Clear;
SQL.Add('SELECT * FROM data ORDER BY RAND(id)');
Open;

No comments:

Post a Comment