Mongodb Query 질문 - rank

Question

oracle sql &#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;select * from (with t1 as (select 1 parentkey, 1 key, 1 version from dualunionselect 1 parentkey, 2 key, 2 version from dualunionselect 2 parentkey, 3 key, 1 version from dual)select RANK() OVER (PARTITION BY parentkey ORDER BY version DESC ) as rk ,a.* from t1 a) where rk &#61; 1&#61;> parentkey 가 같은 애들중에서 버전이 가장 높은 row를 조회하고 싶은 쿼리&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;위 오라클 쿼리처럼 결과값을 mongodb에서 조회하고 싶은데..당최 잘 안되네요.. mapreduce 도 잘 맞지 않는 것 같고..aggregate() 해도 잘 안되고..고수님들 도움 부탁드립니다.

Mongodb Query 질문 - rank

0개의 답변

#rank 목록