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
Roast it!
Roast topics
Find topics
Find it!
Roast topics
Find topics
Find it!