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