Anonymous user
Category:SMEQL: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| (2 intermediate revisions by 2 users 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,
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
----------------
empID
Line 50 ⟶ 53:
* '''union'''(table_1, table_2)
A "column table" is merely a way to represent or store column information in tabular form. SMEQL provides a shortcut syntax that is similar to an SQL "WHERE" clause. Any place above where a column-table is required, one can use the shortcut syntax within square brackets "[...]" (not to be confused with "optional" syntax indicators). Column tables potentially allow you to "calculate" column lists instead of having to type them in manually.
More info can be found at: http://www.c2.com/cgi/wiki?TqlRoadmap
| |||