phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Swapna Swapna <talktoswa...@gmail.com>
Subject Question on FIRST_VALUE
Date Thu, 05 May 2016 00:54:34 GMT
HI,

Can anyone please help me to clarify this function signature:

*FIRST_VALUE (expression
<https://phoenix.apache.org/language/index.html#expression> ) WITHIN GROUP
( ORDER BY expression
<https://phoenix.apache.org/language/index.html#expression>)*

In addition to the below example queries we have:

FIRST_VALUE(name) WITHIN GROUP (ORDER BY salary DESC)

FIRST_VALUE(ID=1 OR NAME='Hi') WITHIN GROUP (ORDER BY salary DESC)

 Can I pass multiple columns to this function like the below:

FIRST_VALUE(id, name) // multi-columns

Regards

Swapna

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message