diff options
| author |  Adam Chlipala <adamc@hcoop.net> | 2008-08-21 13:59:49 -0400 |
|---|---|---|
| committer | Adam Chlipala <adamc@hcoop.net> | 2008-08-21 13:59:49 -0400 |
| commit | 4832e63e1f6c7b5bb7c098e371c794111f32f878 (patch) | |
| tree | d2df75857d17583826cdc8b4a182607d237a31b1 /tests | |
| parent | 71e2a7c3c0fd3cbf7e472e85b491ed890fe5976c (diff) | |
Basic GROUP BY
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/group_by.lac | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/tests/group_by.lac b/tests/group_by.lac new file mode 100644 index 00000000..2b5d4dd1 --- /dev/null +++ b/tests/group_by.lac @@ -0,0 +1,5 @@ +table t1 : {A : int, B : string, C : float} +table t2 : {A : float, D : int} + +val q1 = (SELECT * FROM t1 GROUP BY t1.B) +val q2 = (SELECT * FROM t1, t2 GROUP BY t1.B, t2.D, t1.A) |