就是一个商城平台,想每一页显示 “更多不同卖家” 的商品
比如 A 最近上了 5 个商品,B 最近上了 8 个商品
更早前 C,D,E,F 上架了一个商品
那时间排序第一页就全是 AB 的商品了,这不行
比如 A 最近上了 5 个商品,B 最近上了 8 个商品
更早前 C,D,E,F 上架了一个商品
那时间排序第一页就全是 AB 的商品了,这不行
解决方案 »
- oracle
- 求一存储过程,请大虾帮忙!
- union简单问题
- oracle package question~~!!
- Oracle怎么连最基本的SQL语法都不支持?
- windows2000环境下oracle816升级到oracle9i,有什么需要注意的地方?特别欢迎有经验的朋友提供建议
- sql语句索引问题
- [在线等]ORACLE触发器编译错误,到底是我那地方写错了?
- 关于Pro*C连接远程数据库问题
- 删除数据的问题
- 求select语句最后加一行合计
- ERROR Unknown error when running consumer: (kafka.tools.ConsoleConsumer$)
select 'A' AS U,1 T,sysdate+1 D FROM DUAL UNION ALL
select 'A' AS U,2,sysdate+2 D FROM DUAL UNION ALL
select 'A' AS U,3,sysdate+3 D FROM DUAL UNION ALL
select 'A' AS U,4,sysdate+4 D FROM DUAL UNION ALL
select 'A' AS U,5,sysdate+5 D FROM DUAL UNION ALL
select 'B' AS U,1,sysdate+1 D FROM DUAL UNION ALL
select 'B' AS U,2,sysdate+2 D FROM DUAL UNION ALL
select 'B' AS U,3,sysdate+3 D FROM DUAL UNION ALL
select 'B' AS U,4,sysdate+4 D FROM DUAL UNION ALL
select 'B' AS U,5,sysdate+5 D FROM DUAL UNION ALL
select 'B' AS U,6,sysdate+6 D FROM DUAL UNION ALL
select 'B' AS U,7,sysdate+7 D FROM DUAL UNION ALL
select 'B' AS U,8,sysdate+8 D FROM DUAL UNION ALL
select 'C' AS U,1,sysdate D FROM DUAL UNION ALL
select 'D' AS U,1,sysdate D FROM DUAL UNION ALL
select 'E' AS U,1,sysdate D FROM DUAL UNION ALL
select 'F' AS U,1,sysdate D FROM DUAL )
select u,t from a where (select count(*) from a b where b.u = a.u and b.d >a.d) < 2;
select a.name,row_number()over(partition by a.name order by a.上架时间 desc nulls last) rn from a
order by a.上架时间 desc nulls last
) a where a.rn<3