Conversion using the Max function, but because of the need to transform existing in the field of Chinese string, prompt invalid number, how to solve the

 Max (case when "SubjectTitle='type'" then "SubjectText" else null end) as type 

It's about writing so much

CodePudding user response:

Even in Chinese, also can use Max, your prompt problem has nothing to do with you,,,

CodePudding user response:

reference 1st floor js14982 response:

even if is in Chinese, you can also use the Max, your prompt problem has nothing to do with you,,,

If you remove this sentence is not prompt ~ that is it a problem

CodePudding user response:

Direct query case when "SubjectTitle"='type' then "SubjectText" else null end
Or "SubjectTitle" error?

CodePudding user response:

reference js14982 reply: 3/f

direct query case when "SubjectTitle"='type' then "SubjectText" else null end
Or "SubjectTitle" error?

The give me check is the previously defined fields defined as the number