FIRST/FIRST_VALUE function returning empty value

Hi All,

I have to select records from an index, and have to select the latest values for a Mobile number. There can be more than one record for each mobile number.

I am using FIrst function for the same and it is returning me the latest values. However I have to ignore if the latest value is blank and select the next value

Is there a way/function to select the latest non blank value from an index using sql Api

You could use the IS NOT NULL in the WHERE clause.
Can you post the query you're trying to run?

1 Like