Category:SMEQL: Difference between revisions
Content added Content deleted
m (Filling out language template) |
No edit summary |
||
Line 29: | Line 29: | ||
Here is a sample to whet your appitite: |
Here is a sample to whet your appitite: |
||
srt = orderBy(Employees, |
srt = orderBy(Employees, [dept, salary], order) |
||
top = group(srt, [(dept) dept2, max(order) order]) |
top = group(srt, [(dept) dept2, max(order) order]) |
||
join(srt, top, a.dept=b.dept2 and b.order - a.order < 6) |
join(srt, top, a.dept=b.dept2 and b.order - a.order < 6) |
||
Line 36: | Line 36: | ||
this table schema: |
this table schema: |
||
Employees |
table: Employees |
||
---------------- |
---------------- |
||
empID |
empID |