Login
From:
Java, SQL and jOOQ.
(Uncensored)
subscribe
Oracle's way to get multiple values in a top 1 per group query
https://blog.jooq.org/getting-top-1-values-per-group-in-oracle/
links
backlinks
Tagged with:
sql
oracle
keep
aggregate functions
any value
top-1-per-category
Getting top 1 per group values is a bit tricky in SQL in general. This post explains how to do this with Oracle when multiple values per group are requested
Roast topics
Find topics
Find it!