Sql代码
www.2cto.com
SELECT * FROM t_room WHERE fid >=
(((SELECT MAX(fid) FROM t_room) -(SELECT MIN(fid) FROM t_room)) * RAND() +
(SELECT MIN(fid) FROM t_room)) LIMIT 10
(SELECT MIN(fid) FROM t_room)) LIMIT 10