I have limited experience with SQL and need to write an expression in our software. I want to get the minimum value based on an if statement. Here's the function in plain English.
What is the minimum date for data1 when data2 equals textABC?
Case when data2 is textABC min(data1) else end
Aucun commentaire:
Enregistrer un commentaire