- 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
- Financial Functions
- External Library Functions
- Composite-Table-Related Functions
-
Functions
- #c
- $(db)sql;…
- ${macroExp}
- =expression
- >statement
- [a:b]
- @
- A()
- A.( x )
- [a 1 ,…a n ]
- abs()
- acos()
- acosh()
- age()
- align()
- ali_client()
- ali_close()
- ali_query()
- alter()
- and()
- append()
- argpost
- array()
- asc()
- asin()
- asinh()
- atan()
- atanh()
- attach()
- avg()
- base64 ()
- between()
- bits()
- bool()
- break {a}
- C
- Cr()
- calc()
- call()
- call path/dfx( … )
- callx()
- cand()
- canvas()
- case()
- ceil()
- cellname()
- ch.()
- channel()
- char()
- chn()
- clear
- clipboard()
- close()
- cmp()
- cor()
- combin()
- commit()
- concat()
- conj()
- conjx()
- connect()
- contain()
- cos()
- cosh()
- count()
- cov()
- covm()
- create()
- cs.()
- cum()
- cursor()
- date()
- datetime()
- day()
- days()
- decimal()
- delete()
- deq()
- derive()
- dfx ( … )
- diff()
- digits()
- directory()
- dis()
- dism()
- dup()
- elapse()
- end s
- enum()
- env()
- eq()
- error()
- eval()
- es_close ()
- es_delete()
- es_head()
- es_open()
- es_get()
- es_post()
- es_put()
- execute()
- exists()
- exp()
- export()
- f@o(…)
- Faccrint()
- Faccrintm()
- fact()
- false
- Fcoupcd()
- Fcoups()
- Fdb()
- Fddb()
- Fdisc()
- Fduration()
- fetch()
- field()
- file()
- filename()
- find()
- Fintrate()
- Firr()
- float()
- floor()
- Fmirr()
- fname()
- fno()
- Fnper()
- Fnpv()
- for
- fork
- format()
- Fpmt()
- Fprice()
- Frate()
- Freceived()
- Fsln()
- Fsyd()
- ftp_cd()
- ftp_client()
- ftp_close()
- ftp_dir()
- ftp_get()
- ftp_mget()
- ftp_mput()
- ftp_put()
- func()
- Fv()
- Fvdb()
- Fyield()
- gcd()
- goto C
- group()
- groupi()
- groupn()
- groups()
- groupx()
- hash()
- hbase_close()
- hbase_cmp()
- hbase_filter()
- hbase_filterlist()
- hbase_get()
- hbase_open()
- hbase_scan()
- hdfs_client()
- hdfs_close()
- hdfs_dir()
- hdfs_file()
- hive_client()
- hive_close()
- hive_cursor()
- hive_execute ()
- hive_query()
- hosts()
- hour()
- httpfile()
- I()
- icursor()
- icount()
- id()
- if
- if()
- ifa()
- ifdate()
- ifn()
- ifnumber()
- ifr()
- ifstring()
- ift()
- iftime()
- ifv()
- ifx_close()
- ifx_conn()
- ifx_cursor()
- ifx_listfrag()
- ifx_savefrag()
- ifx_setfrag()
- ifx_takefrag()
- import()
- index()
- inf()
- insert()
- int()
- interval()
- inv()
- inverse()
- invoke()
- isalpha()
- isdigit()
- isect()
- iselect()
- islower()
- isolate()
- isupper()
- iterate()
- join()
- joinx()
- json()
- k()
- k{}
- kafka_close()
- kafka_commit()
- kafka_poll()
- kafka_subscribe()
- key()
- keys()
- lcm()
- left()
- len()
- lg()
- like()
- linefit()
- ln()
- lock()
- long()
- lower()
- m()
- mae()
- max()
- maxp()
- mcursor()
- md5()
- median()
- memory()
- merge()
- Mergex()
- mid()
- millisecond()
- min()
- minp()
- minute()
- mode()
- modify()
- mongo_close ()
- mongo_insert()
- mongo_open()
- mongo_shell()
- month()
- movefile()
- mul()
- mse()
- n.f( x )
- name()
- new()
- news()
- next{a}
- nodes()
- norm()
- not()
- now()
- null
- number()
- nvl()
- olap_close()
- olap_open()
- olap_query()
- open()
- or()
- output()
- p()
- pad()
- parse()
- paste()
- pca()
- pdate()
- pearson()
- penum()
- periods()
- permut()
- pfind()
- pi()
- pivot()
- pls()
- pmax()
- pmin()
- polyfit()
- pos()
- power()
- prior()
- proc()
- product()
- property()
- pseg()
- pselect()
- pseudo()
- psort()
- ptop()
- push()
- query()
- r.( x )
- r.F
- r.F=x
- rand()
- rands()
- range()
- rank()
- ranki()
- rankm()
- ranks()
- read()
- record()
- redis()
- redis_close()
- redis_cluster()
- redis_get()
- redis_getrange()
- redis_hkeys()
- redis_hlen()
- redis_hmget()
- redis_hvals()
- redis_keys()
- redis_lindex()
- redis_llen()
- redis_lrange()
- redis_pool()
- redis_scard()
- redis_sdiff()
- redis_select()
- redis_sentinel()
- redis_shared()
- redis_sharedpool()
- redis_sinter()
- redis_sismember()
- redis_smembers()
- redis_srandmember()
- redis_strlen()
- redis_sunion()
- redis_type()
- redis_zcard()
- redis_zcount()
- redis_zrange()
- redis_zrangebyscore()
- redis_zrank()
- redis_zscore()
- regex()
- register()
- rename()
- replace()
- report_config()
- report_exportHtml()
- report_exportPdf()
- report_exportXls()
- report_open()
- report_run()
- reset()
- result
- return xi
- rgb()
- right()
- rollback()
- round()
- run()
- rvs()
- sap_client ()
- sap_close()
- sap_cursor ()
- sap_execute ()
- sap_getparam ()
- sap_table ()
- savepoint()
- second()
- segp()
- select()
- seq()
- sg()
- shift()
- sign()
- sin()
- sinh()
- size()
- sizeof()
- skip()
- sleep()
- sort()
- sortx()
- spark_client()
- spark_close()
- spark_cursor()
- spark_query()
- spearman()
- split()
- sqlparse()
- sqltranslate()
- SQL +
- substr()
- stax_close ()
- stax_connect ()
- stax_query ()
- sqrt()
- step()
- string()
- sum()
- swap()
- switch()
- sync()
- system()
- T()
- T.()
- tan()
- tanh()
- time()
- to()
- top()
- total()
- transpose()
- trim()
- true
- try
- union()
- update()
- upper()
- urlencode ()
- v()
- var()
- words()
- workday()
- workdays()
- write()
- ws_call()
- ws_client()
- xjoin()
- xjoinx()
- xlscell()
- xlsclose()
- xlsexport()
- xlsimport()
- xlsopen()
- xlswrite()
- xml()
- xor()
- 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()
- z()
- zip()
- zip_add()
- zip_close ()
- zip_compress()
- zip_del()
- zip_encrypt()
- zip_extract()
- zone()
- Intersection of sequences
- Comparison operation
- Hexadecimal long integer
- Modulus
- Concatenation of sequences
- Arithmetic operations
- Compound assignment
- String
- String concatenation
- Concatenation of serial bytes
- Alignment arithmetic operations
- Difference between sequences
- Union of sequences
- Multiplication of sequences
- Table sequence constant
- Loop functions
- 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
redis_zrank()
Description:
Determine the ranking of a member in a sorted set.
Syntax:
redis_zrank(con,key,member)
Note:
External library function. By default the members in a sorted set is arranged in an ascending order; use @z option to arrange them in a descending order.
The rankings start with 0, meaning the ranking of the member with the smallest score is 0.
If the given member doesn’t belong to the sorted set, return an empty table.
Options:
@z Arrange sorted set members in descending order.
Parameters:
|
con |
Database connection string |
|
key |
Sorted set name |
|
member |
Sorted set member |
Return value:
Table sequence
Example:
|
|
A |
|
|
1 |
=redis("192.168.18.131:6379","runqian") |
|
|
2 |
=redis_zrangebyscore(A1,"salary","-inf","+inf","WITHSCORES") |
|
|
3 |
=redis_zrank(A1,"salary","jack") |
|
|
4 |
=redis_zrank@z(A1,"salary","jack") |
|
