Category:SMEQL: Difference between revisions

no edit summary
m (Filling out language template)
No edit summary
 
Line 29:
Here is a sample to whet your appitite:
 
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)
Line 36:
this table schema:
 
table: Employees table
----------------
empID
Anonymous user