New Contributor
since ‎2021.06.14
‎2021.06.14

## User Statistics

• 326 Posts
• 0 Solutions
• 0 Kudos given

## UNC filenames

on windows, we can load scripts with UNC filename:\l //wi/c/tmp.qwe can load csv:t: ... 0:`://wi/c/tmp.csvbut we can't save:save `://wi/c/t.csv'//wi/c/t.csv. OS reports: The specified path is invalid.`://wi/c/t.txt 0:enlist"text"'//wi/c/t. OS reports...

## by...where

i need to find groups of a where b contains 8 9q)show t:([]a:3 3 3 4 4;b:7 7 8 8 9)a b---3 73 73 84 84 9i can do this in qq)where all each 8 9 in/:(t.b group t.a),4can i solve the same in sql something likeq)select by a where all b in 8 9 ... ?many t...

## idistinct

q)show t:([]a:1 1 1;b:1 2 2;c:`a`b`c)a b c-----1 1 a1 2 b1 2 ci can find distinct rows considering a,b byq)distinct select a,b from ta b---1 11 2but need to incorporate the c column so the result i want might bea b c------1 1 a1 2 bso an idistinct wo...

## roll date types

interesting treatment of n?0 for different zeroes. show the range of many rolls:q)flip (min;max)@'\:10000?/:"idmpz"\$\:0-2147220343 2147473647 2000.01.01 2003.12.31 2000.01 2003.12 2000.01.01D15:44:08.050010204 2003.12.31D18:08:55.7036925922000.01.01T...