Skip to content
CodeWiki
Practice
Paths
Tracks
Cheatsheets
Playground
Glossary
AI era
Search
⌘K
English
English
Chinese
Practice
Paths
Tracks
Cheatsheets
Playground
Glossary
AI era
English
English
Chinese
Practice
/
Quiz
/
Data and databases
/
Advanced SQL
A report must return every product tied at either of the two highest distinct revenue amo…
from Advanced SQL
SQLite 3.45.1
intermediate
1 min
A report must return every product tied at either of the two highest distinct revenue amounts in each category. Which function matches that requirement?
ROW_NUMBER() filtered to values at most 2
RANK() filtered to values at most 2
DENSE_RANK() filtered to values at most 2
Check
Ask AI about this kata
Report an error
next kata
What rows does this SQLite query print?
Predict the output
A new version is available
Reload