Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
relational_database:subquery [2021/02/07 04:16] – ↷ Page moved from database:subquery to relational_database:subquery ledyxrelational_database:subquery [2021/02/07 04:16] (current) – ↷ Links adapted because of a move operation ledyx
Line 151: Line 151:
  
 === TOP-N query === === TOP-N query ===
-Inline View에 먼저 정렬을 수행하고, 정렬된 결과 중에서 WHERE 절에서 [[database:built-in_function#rownum|ROWNUM]]을 사용하여 일부 데이터를 추출하는 Subquery+Inline View에 먼저 정렬을 수행하고, 정렬된 결과 중에서 WHERE 절에서 [[relational_database:built-in_function#rownum|ROWNUM]]을 사용하여 일부 데이터를 추출하는 Subquery
  
relational_database/subquery.1612671390.txt.gz · Last modified: 2021/02/07 04:16 by ledyx