Skip to content
ashigeru edited this page Sep 14, 2010 · 3 revisions

.h1 Projection

SELECT
    h
FROM
    Hoge h

.h1 Delegation

APPLY
    callback(h)
FROM
    Hoge h
APPLY
    batch(h)
    EVERY 200
FROM
    Hoge h

.h1 Filtering

SELECT
    h
FROM
    Hoge h
WHERE
    h.value == 0
SELECT
    h
FROM
    Hoge h
WHERE
    h.value == 0
AND
    EXISTS fk IN h.keys (fk == Key("Some", "thing"))

.h1 Sorting

SELECT
    Key(h)
FROM
    Hoge h
ORDER BY
    h.value ASC

Clone this wiki locally