Category:SMEQL: Difference between revisions
Content added Content deleted
No edit summary |
No edit summary |
||
Line 14: | Line 14: | ||
t2 = bar(t1, zog) |
t2 = bar(t1, zog) |
||
to get this: |
|||
Into: |
|||
t2 = bar(foo(blah), zog) |
t2 = bar(foo(blah), zog) |
||
Line 42: | Line 42: | ||
Here's a brief summary of common SMEQL operators: |
Here's a brief summary of common SMEQL operators: |
||
* '''calc'''(table, columnTable) // similar to SELECT clause in SQL |
* '''calc'''(table, columnTable) // ''similar to SELECT clause in SQL'' |
||
* '''filter'''(table, expression) // similar to WHERE clause in SQL |
* '''filter'''(table, expression) // ''similar to WHERE clause in SQL'' |
||
* '''group'''(table, columnTable) // roughly similar to GROUP BY in SQL |
* '''group'''(table, columnTable) // ''roughly similar to GROUP BY in SQL'' |
||
* '''join'''(table_1, table_2, expression) |
* '''join'''(table_1, table_2, expression) |
||
* '''leftJoin'''(table_1, table_2, expression) |
* '''leftJoin'''(table_1, table_2, expression) |
||
* '''orderBy'''(table, columnTable, [sequenceColumn]) // sorts or produces sequence numbers |
* '''orderBy'''(table, columnTable, [sequenceColumn]) // ''sorts or produces sequence numbers'' |
||
* '''union'''(table_1, table_2) |
* '''union'''(table_1, table_2) |
||