Help for this page

Select Code to Download


  1. or download this
       SELECT * FROM tab1
    
  2. or download this
       $tab1
    
  3. or download this
       SELECT *
       FROM tab1
       WHERE col1 = 'hello' AND col2 = 5
          OR col1 = 'world' AND col2 = 7
    
  4. or download this
       $tab1 matching Relation:{
         col1 => 'hello', col2 => 5,
         col1 => 'world', col2 => 7
       }
    
  5. or download this
       SELECT col1, col2, col3, col5, col6, col7, col8
       FROM tab
    
  6. or download this
       $tab@{!bigcol4}
    
  7. or download this
       SELECT age, ctry, COUNT(*) AS count_per_age_ctry
       FROM people
       GROUP BY age, ctry
    
  8. or download this
       $people@{#@count_per_age_ctry <- !age,ctry}
    
  9. or download this
       $x := $y
       $y := $x
    
  10. or download this
         recipe count_heads (&$count : NNInt, $search : Text,
                 $people ::= $fed.data.db1.people) {
    ...
             }
             $count := r# ($people where <nlx.lib.filt>( $>search ))
         }
    
  11. 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
         }