Getting Top 1 Values Per Group in Oracle
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 المشاركات
1كيلو بايت مشاهدة