谁能看得懂这条SQL 求解释

qingkong 问答 1611

select a.id,a.product_title,a.volume,a.imgurl,
min(c.price) as price
from lkt_product_list AS a RIGHT JOIN (select min(price) price,pid from lkt_configure group by pid) AS c ON a.id = c.pid
where a.status = 0 and a.num >0 and s_type like ‘%4%’
group by c.pid order by a.volume desc limit 10,10

回复

共1条回复 我来回复
  • 疯子技师
    疯子技师 评论

    这是首页分页数据查询

    2020年5月5日 13:34 0条评论
QR code