语句是:select distinct(字段名或*) from 表1 a left join 表2 b on a.字段=b.字段 where 条件 order by a.主键(b.主键,rand())(desc) limit start lentgh;
mysql数据库随机查询distinct
最新推荐文章于 2024-01-22 07:59:11 发布
语句是:select distinct(字段名或*) from 表1 a left join 表2 b on a.字段=b.字段 where 条件 order by a.主键(b.主键,rand())(desc) limit start lentgh;