//sum int超界就算不出来了
q)t1 : ([] name:`symbol$(); age:`int$())
q)t1
name age
--------
q)`t1 insert (10#`abc;til 10)
0 1 2 3 4 5 6 7 8 9
q)t1
name age
--------
abc0
abc1
abc2
abc3
abc4
abc5
abc6
abc7
abc8
abc9
//少量数据是正常的
q)select sage:sum age from t1
sage
----
45
q)delete from `t1
`t1
q)t1
name age
--------
//插入大量数据
q)\t `t1 insert (1000000#`abc;til 1000000)
31
q)select sa:sum age from t1
sa
--
q)t1[1]
name| `abc
age | 1i
q)t1[999999]
name| `abc
age | 999999i
q)select count name from t1
name
-------
1000000
q)select count age from t1
age
-------
1000000
q)select sum age from t1
age
---
q)select avg age from t1
age
--------
499999.5
//强制类型转换为long就可以了
q)select sum age from t1 where age<10
age
---
45
q)select sum "j"$age from t1 where age<10
age
---
45
q)select sum "j"$age from t1
age
------------
499999500000
//想按数字个数排序,结果不对
q)count 12
1
q)count "12"
2
q)\t temp:select count name by count string age mod 10 from t1
93
q)temp
x| name
-------| -------
1000000| 1000000
q)\t temp:select count name by count string age from t1
203
q)temp
age| name
-------| -------
1000000| 1000000
q)count string 992
3