- Data Type
- Operators
- Mathematical Functions
- String Functions
- Date/Time Functions
- Sequence Functions
- Table Sequence Functions
- Loop Functions
- Functions for Associative Operations
- File-handling Functions
- Database Functions
- Cursor Functions
- Statements
- System- & interface-related Functions
- Cluster Computing Functions
- Chart-plotting Functions
- External Library Functions
- Composite-Table-Related Functions
- Remote-service-related functions
- Simple SQL
-
Functions
- #c
- $(d)dql...
- $(db)sql;…
- ${macroExp}
- =expression
- >statement
- [a:b]
- @
- @x:…
- A()
- A.( x,… )
- [a 1 ,…a n ]
- abs()
- acos()
- acosh()
- age()
- align()
- ali_open()
- ali_close()
- ali_query()
- alter()
- and()
- append()
- argpost
- array()
- asc ()
- asin()
- asinh()
- atan()
- atanh()
- attach()
- avg()
- base64 ()
- between ()
- bi()
- bits()
- bit1( x )
- bit1( x,y )
- blob()
- bool ()
- break {a}
- C
- Cr()
- calc()
- call()
- call path/spl( … )
- calls path/spl( … )
- callx()
- cand()
- canvas()
- case()
- ceil()
- cellname()
- ch.()
- channel()
- char()
- chardetect()
- charencode()
- chi_p()
- chi2inv()
- chn()
- clear
- clipboard()
- close()
- cmp()
- cor()
- comabs()
- comangle()
- combin()
- comconj()
- comexp()
- comimage()
- commit()
- compair()
- complex()
- comreal()
- comsign()
- comstr()
- comunwrap()
- concat()
- conj()
- connect()
- contain()
- corskew()
- cos()
- cosh()
- count()
- cov()
- covm()
- create()
- cs.()
- cum ()
- cursor()
- date()
- datederive()
- dateinterval()
- datetime()
- day()
- days()
- decimal()
- delete()
- deq()
- derive()
- det()
- diff()
- digits()
- directory()
- dis()
- dism()
- dql()
- dup()
- dynadb._close()
- dynadb.execute()
- dyna_open()
- dynadb._query()
- dynadb.table()
- E()
- E()
- elapse()
- elasticnet()
- end s
- enum()
- env()
- eq()
- error()
- eval()
- es_close()
- es_delete ()
- es_export ()
- es_head ()
- es_open ()
- es_get ()
- es_post ()
- es_put ()
- exec()
- execute()
- exists()
- exp()
- export()
- eye()
- f@o(…)
- Faccrint()
- Faccrintm()
- fact()
- false
- Fcoupcd()
- Fcoups()
- Fdb()
- Fddb()
- Fdisc()
- Fduration()
- fetch()
- field()
- file()
- filename()
- fill()
- find()
- Fintrate()
- finv()
- Firr()
- fisher_p ()
- fjoin()
- float()
- floor()
- Fmirr()
- fname()
- fno()
- Fnper()
- Fnpv()
- for
- fork
- format()
- Fpmt()
- Fprice()
- Frate()
- Freceived()
- freq ()
- Fsln()
- Fsyd()
- ftp_cd()
- ftp_open()
- ftp_close()
- ftp_dir()
- ftp_get()
- ftp_mget()
- ftp_mput()
- ftp_put()
- func()
- Fv()
- Fvdb()
- Fyield()
- get()
- gcd()
- goto C
- group()
- groupi()
- groupn()
- groups()
- groupx()
- hash()
- hbase_close()
- hbase_cmp()
- hbase_filter()
- hbase_filterlist()
- hbase_get()
- hbase_open()
- hbase_rest()
- hbase_scan()
- hdfs_open()
- hdfs_close()
- hdfs_dir()
- hdfs_download()
- hdfs_exists()
- hdfs_file()
- hdfs_upload()
- hdfs_write()
- hive_open()
- hive_close()
- hive_cursor()
- hive_execute ()
- hive_query()
- hosts()
- hour ()
- httpfile()
- I()
- i()
- icursor()
- icount()
- id()
- if
- if()
- ifa()
- ifdate()
- ifind()
- ifn()
- ifnumber()
- ifpure()
- ifr()
- ifstring()
- ift()
- iftime()
- ifv()
- ifx_close()
- ifx_conn()
- ifx_cursor()
- ifx_listfrag()
- ifx_savefrag()
- ifx_setfrag()
- ifx_takefrag()
- import()
- impute()
- index()
- inf()
- influx_close()
- influx_insert()
- influx_open()
- influx_query()
- influx2_close()
- influx2_delete()
- influx2_open()
- influx2_query()
- influx2_rest()
- insert()
- int()
- interval()
- inv()
- inverse()
- invoke()
- isalpha()
- isdigit()
- isect()
- iselect()
- islower()
- isolate()
- isupper()
- iterate()
- j()
- join()
- joinx()
- json()
- jvm()
- k()
- kafka_close()
- kafka_commit()
- kafka_offset()
- kafka_open()
- kafka_poll()
- kafka_send()
- key()
- keys()
- kmeans()
- lasso()
- lcm()
- left()
- len()
- lg()
- like()
- linefit()
- lineplan()
- ln()
- load()
- lock()
- long()
- lower()
- m()
- mae()
- max()
- maxp()
- mcumsum()
- mcursor()
- md5()
- median()
- memory()
- merge()
- mfind()
- mi()
- mid()
- millisecond()
- min()
- minp()
- minute()
- mmean()
- mnorm()
- mode()
- modify()
- mongo_close ()
- mongo_open()
- mongo_shell()
- month()
- movefile()
- mul()
- mse()
- mstd()
- msum()
- mvp()
- n.f( x )
- name()
- new()
- news()
- next{a}
- nodes()
- norm()
- norminv()
- not()
- now()
- ntile ()
- null
- number()
- numnorm()
- nvl()
- o()
- olap_close()
- olap_open()
- olap_query()
- ones()
- open()
- or()
- output()
- p()
- pad()
- parse()
- paste()
- pca()
- pdate ()
- pearson()
- penum()
- periods()
- permut()
- pfind()
- pi()
- pivot()
- pjoin()
- pls()
- pmax()
- pmin()
- polyfit()
- pos()
- power()
- prior()
- proc()
- product()
- property()
- pseg()
- pselect()
- pseudo()
- psort()
- ptop()
- push()
- Qconnect()
- Qdirectory()
- Qenv()
- Qfile()
- Qload()
- Qlock()
- Qmove()
- query()
- r.( x )
- r.F
- r.F=x
- r2dbc_close()
- r2dbc_exec()
- r2dbc_open()
- r2dbc_query()
- rand()
- rands()
- range()
- rank()
- ranki()
- rankm()
- ranks()
- read()
- record()
- redis_close()
- redis_command()
- redis_open()
- regex()
- register()
- remainder()
- rename()
- replace()
- report_config()
- report_exportDoc()
- report_exportHtml()
- report_exportPdf()
- report_exportXls()
- report_open()
- report_run()
- reset()
- result
- return xi
- rgb()
- ridge()
- right()
- rollback()
- round()
- run()
- rvs()
- s3_ bucket ()
- s3_ close ()
- s3_ copy ()
- s3_ file ()
- s3_ list ()
- s3_ open ()
- sap_client()
- sap_close()
- sap_cursor ()
- sap_execute ()
- sap_getparam ()
- sap_table ()
- savepoint()
- sbs()
- se()
- second()
- segp()
- select()
- seq()
- sert()
- setenum()
- sf_close()
- sf_open()
- sf_query()
- sf_wsdlclose()
- sf_wsdlopen()
- sf_wsdlquery()
- sf_wsdlview()
- sg()
- shift()
- sign()
- sin()
- sinh()
- size()
- skew ()
- skip()
- sleep()
- smooth()
- sort()
- sortx()
- spark_open()
- spark_close()
- spark_cursor()
- spark_query()
- spark_read()
- spearman()
- split()
- splserver()
- sqlparse()
- sqltranslate()
- substr ()
- stax_close ()
- stax_open()
- stax_cursor()
- stax_query ()
- sqrt()
- step()
- string()
- structure
- sum()
- svm()
- swap()
- switch()
- syncfile( hs,p )
- system()
- T()
- tarcorskew()
- tan()
- tanh()
- time()
- tinv()
- to()
- top()
- total()
- transpose()
- trim()
- true
- try
- ttest_p()
- union()
- update()
- upper()
- urlencode()
- uuid()
- v()
- var()
- web_crawl()
- webhdfs()
- webhdfs_file()
- words()
- workday()
- workdays()
- write()
- ws_call()
- ws_client()
- xjoin()
- xjoinx()
- xlscell()
- xlsclose()
- xlsexport()
- xlsimport()
- xlsopen()
- xlswrite()
- xml()
- xor()
- xunion()
- year()
- ym_build_model()
- ym_close()
- ym_env()
- ym_exec()
- ym_importance()
- ym_json()
- ym_load_pcf()
- ym_model()
- ym_performance()
- ym_predict()
- ym_present()
- ym_result()
- ym_save_pcf()
- ym_setparam()
- ym_server_quit()
- ym_statistics()
- ym_target()
- zeros()
- zip()
- zip_add()
- zip_close ()
- zip_compress()
- zip_del()
- zip_encrypt()
- zip_extract()
- zip_open()
- Intersection of sequences
- Comparison operation
- Hexadecimal long integer
- Modulus
- Concatenation of sequences
- Arithmetic operations
- Compound assignment
- String
- String concatenation
- Alignment arithmetic operations
- Difference between sequences
- Union of sequences
- Multiplication of sequences
- Table sequence constant
- Record constant
- The writing rules for expression x in loop functions
- Batch Computation
- Identifier
- Opposite Number
- Empty Sequence
- Assignment
- Value Computation and Assignment
- Escape Character
- Logical Operations
- Long Integer
- Cell type
- Code block type
- Chart Elements
range(s,e,k:n)
Description:
Get the beginning members of the specified segment and its next segment.
Syntax:
range(s,e,k:n)
Note:
The function evenly divides an interval defined by starting data s and ending data e (both parameters can be integers) into n segments and returns the beginning member of the kth segment and that of the (k+1)th segment as a two-member sequence. The precision of the retunred data is determined by the date type. For example, the maximum precision date type data is day, and that of datetime data is second. If parameter k is absent, return the beginning members and ending members of all segments, which means the returned sequence will have n+1 members.
Parameter:
|
s |
Starting data |
|
e |
Ending data |
|
k |
The kth segment whose beginning member is to be returned |
|
n |
The number of segments data is divided |
Return value:
A sequence
Example:
|
|
A |
|
|
1 |
=range(date("1982-08-09"),date("1992-08-09"),2:3) |
The max precison of the date data is day
|
|
2 |
=range(datetime("2006-01-01 10:20:30:111"),datetime("20016-01-01 10:20:30:111"),2:3) |
The max precison of the datetime data is second
|
|
3 |
=range(1,9,2:3) |
Parameter s and e are integers
|
|
4 |
=range(date("1982-08-09"),date("1992-08-09"),3) |
As parameter k is absent, return the beginning members and ending members of all segments
|
