引導式測驗 · 中等 等級
如何使用 AI 測驗編寫 SQL 視窗函數
檢查 SQL 視窗分區、排名關係和運行總計框架以及購買範例、缺失日期和最新事件選擇。
問題 1 的 8
對於 5、7 和 4 的訂購購買,哪些逐行運行總計與指南的框架相符?
預覽每個問題8 問題
當您參加測驗時,就會出現答案和解釋。
- 對於 5、7 和 4 的訂購購買,哪些逐行運行總計與指南的框架相符?
- 5, 7 and 4
- 5, 12 and 16
- 16, 16 and 16
- 5, 14 and 12
- 對於降序分數 100、100 和 90,RANK 會產生哪個序列?
- 1, 2 and 3
- 1, 1 and 2
- 2, 2 and 3
- 1, 1 and 3
- 哪一個函數給出並列分數 100、100 和 90 的排名 1、1 和 2?
- DENSE_RANK
- ROW_NUMBER
- RANK
- LAG
- 最新事件查詢使用僅按兩個事件共享的時間戳記排序的 ROW_NUMBER。在它們之間做出可預測的選擇需要什麼?
- Remove the account partition
- Replace the final result with an unqualified DISTINCT
- Add an appropriate tie-breaker to the window ordering
- Assume insertion order resolves every tie
- 為什麼每日銷售額的LAG不能代表昨天的銷售額?
- LAG always refers to the first row of the entire table
- The previous recorded row may be separated by missing dates
- LAG automatically groups all dates in one month
- The function replaces missing dates with zero
- An ORDER BY appears inside OVER. What is still needed if the final displayed result must have a specified order?
- Only a PARTITION BY with the same column
- Only a ROWS frame using the same ordering column
- No further clause because window ordering guarantees display order
- A final ORDER BY for the query result
- Why should a tie-breaker not be added indiscriminately to RANK when equal scores should share a rank?
- It can change which rows are peers and therefore change tied ranks
- It leaves peer membership unchanged because only the first ordering column matters
- It changes only the final display order and never the window calculation
- It preserves equal-score ranks while automatically making their row numbers predictable
- In PostgreSQL, how can a query filter rows using a window value calculated in an inner SELECT?
- Use that value in the same SELECT's WHERE without another query level
- Replace OVER with GROUP BY in every case
- Filter in an outer query or common table expression
- Assume every database supports an identical QUALIFY clause