Getting Top 1 Values Per Group in Oracle

a adăugat un sunet Coding

2025-05-31 20:25:34 -

Oracle's way to get multiple values in a top 1 per group query 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: SELECT max(actor_id) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id), max(first_name) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id),...

0 Commentarii 0 Distribuiri 383 Views 0 previzualizare