Category:SMEQL: Difference between revisions

no edit summary
No edit summary
No edit summary
 
(One intermediate revision by one other user not shown)
Line 1:
{{language|SMEQL}}
|site=http://www.c2.com/cgi/wiki?TqlRoadmap
|LCT=no
}}
 
SMEQL is a draft query language that is meant to solve the shortcomings and annoyances of [[SQL]]. SMEQL stands for "structured meta-enabled query language" (pronounced "smeegle").
Line 26 ⟶ 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 33 ⟶ 36:
this table schema:
 
table: Employees table
----------------
empID
Anonymous user