![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
zhang100jie
这个作者很懒,什么都没留下…
展开
-
where后面in 两个条件
select * from tscm_product p where (p.productid,p.supplierid) in(select pp.productid,pp.supplierid from tscm_product pp where pp.productid=100124) 效率不高原创 2012-11-26 13:41:38 · 2349 阅读 · 0 评论 -
取某一列的最大值
[code="java"](select * from (select row_number() over(partition by productid order by commentsequence) rn, t.* ...原创 2016-06-28 15:09:00 · 396 阅读 · 0 评论