# top-1-per-category

Published articles for top-1-per-category.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Getting Top 1 Values Per Group in Oracle

DevFeed: [Getting Top 1 Values Per Group in Oracle](<https://devfeed.tech/articles/getting-top-1-values-per-group-in-oracle-28939.md>)

Original publisher: [Read original article](<https://blog.jooq.org/getting-top-1-values-per-group-in-oracle/>)

Author: lukaseder

Published: 2024-03-01T09:55:41Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [ordering](<https://devfeed.tech/topics/ordering.md>), [JSON](<https://devfeed.tech/topics/json.md>)

Tags: [aggregate-functions](<https://devfeed.tech/tags/aggregate-functions.md>), [any-value](<https://devfeed.tech/tags/any-value.md>), [function](<https://devfeed.tech/tags/function.md>), [json](<https://devfeed.tech/tags/json.md>), [keep](<https://devfeed.tech/tags/keep.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [ordering](<https://devfeed.tech/tags/ordering.md>), [sql](<https://devfeed.tech/tags/sql.md>), [syntax](<https://devfeed.tech/tags/syntax.md>), [top-1-per-category](<https://devfeed.tech/tags/top-1-per-category.md>), [type-safety](<https://devfeed.tech/tags/type-safety.md>), [types](<https://devfeed.tech/tags/types.md>)

### AI overview

A tutorial on selecting the top one or top n values per group in Oracle. It discusses ordering and ties, repetition when projecting multiple columns, Oracle object types and ANY_VALUE in Oracle 21c, and JSON as an alternative workaround.

### Source excerpt

I've blogged about generic ways of getting top 1 or top n per category queries before on this blog. An Oracle specific version in that post used the arcane KEEP syntax: This is a bit difficult to read when you see it for the first time. Think of it as a complicated way to say ... Continue reading Getting Top 1 Values Per Group in Oracle ->