retrieve value from month furthest back in same FY
I have a dataset where rows correspond to data collected at different points in time like so:
SQL – When using a WHEN THEN ELSE statement, how can I remove the ELSE rows?
I have 3 conditions that I am looking for approval dates, all accounted for in WHEN THEN statements. I use the ELSE at the end of this because I know there are some that have not been approved yet and name them ‘N/A’ instead of the date. When I export this list I only want the 3 conditions of the approval dates and not those N/A ones. How can I remove those ELSE results or is there a better way to do this?
SQL Case when statement with hardcoded values
Hi I using the below query to get values FR20 and FR40 when France is selected under my country attribute I am using the below query but not able to get the values.