How to judge in the SQL where clause, that is the first condition grade wouldn't judge the second condition,
Illustrated the yellow part of the first condition is not the second, and so on, thank you!

CodePudding user response:

The case when

CodePudding user response:

reference 1st floor appo_li response:

case when

In the where clause is used in the case when an error, don't know what the reason, the teacher knows how to use?

CodePudding user response:

What's wrong? Stick down to see