- or download this
SELECT * FROM tab1
- or download this
$tab1
- or download this
SELECT *
FROM tab1
WHERE col1 = 'hello' AND col2 = 5
OR col1 = 'world' AND col2 = 7
- or download this
$tab1 matching Relation:{
col1 => 'hello', col2 => 5,
col1 => 'world', col2 => 7
}
- or download this
SELECT col1, col2, col3, col5, col6, col7, col8
FROM tab
- or download this
$tab@{!bigcol4}
- or download this
SELECT age, ctry, COUNT(*) AS count_per_age_ctry
FROM people
GROUP BY age, ctry
- or download this
$people@{#@count_per_age_ctry <- !age,ctry}
- or download this
$x := $y
$y := $x
- or download this
recipe count_heads (&$count : NNInt, $search : Text,
$people ::= $fed.data.db1.people) {
...
}
$count := r# ($people where <nlx.lib.filt>( $>search ))
}
- or download this
updater make_coprime (&$a : NNInt, &$b : NNInt) {
with function gcd (NNInt <-- $a : NNInt, $b : NNInt) {
...
$a := $a div $gcd round Down
$b := $b div $gcd round Down
}