![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
ab13137462255
这个作者很懒,什么都没留下…
展开
-
2021-03-26
select s1.buyer_name, ((sum(round(cast(date_part('day',e.acceptance_time::timestamp-c.time::timestamp) as numeric)) ))/count(s1.buyer_name)) as zqfrom (select sum(a.num) as num, a.contract_id from ces_contract_cn_price a where a.原创 2021-03-26 16:44:45 · 64 阅读 · 0 评论 -
2021-03-18
mysql 中查询某个分类下的最大的前3条的数据怎么查询1,这个问题对我来说是有点复杂的,先把答案的例子发下。SELECT distinct supplier_id ,price FROM ces_contract_back_money aWHERE (SELECT count(*) FROM ces_contract_back_money b WHERE b.supplier_id=a.supplier_id AND b.price>a.price )<5ORDER BY...转载 2021-03-18 16:37:36 · 98 阅读 · 0 评论