SQL取随机多条记录

 

SELECT * FROM soft WHERE s_id >= ((SELECT MAX(s_id) FROM soft)-(SELECT MIN(s_id) FROM soft)) * RAND() + (SELECT MIN(s_id) FROM soft)  LIMIT 9;