Top rank per group: Difference between revisions

Content added Content deleted

Inline

Revision as of 22:25, 3 December 2008

Find the top N rankers per group.

SMEQL

The following SMEQL example returns the top 6 earners in each department based on this table schema:

 table: Employees
 ----------------
 empID
 dept
 empName
 salary

Source Code:

 srt = orderBy(Employees, (dept, salary), order)
 top = group(srt, [(dept) dept2, max(order) order])
 join(srt, top, a.dept=b.dept2 and b.order - a.order < 6)

Revision as of 22:10, 3 December 2008 (view source) 66.120.226.84 (talk) No edit summary ← Older edit		Revision as of 22:25, 3 December 2008 (view source) 66.120.226.84 (talk) No edit summary Newer edit →
Line 1:		Line 1:
			{{task}}

	Find the top N rankers per group.		Find the top N rankers per group.