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

Reply via email to