case-when用法（国外英文资料）.docVIP

case-when用法（国外英文资料） The use of Case in SQL Case has two formats. Simple Case functions and Case search functions. Simple Case function CASE sex WHEN 1 THEN man WHEN two THEN THEN ELSE END -- Case search function CASE WHEN sex = 1 THEN man WHEN sex = 2 THEN woman ELSE END In both ways, you can achieve the same functionality. The simple Case function is relatively simple to write, but there are limitations in terms of functionality compared to the Case search function, such as writing judgment. There is another issue that needs to be noted, and the Case function returns only the first qualifyin