表TABLE_NAME中有A,B,C,D四列,用SQL语句实现:当A列大于等于B列且小于C列时选A列数据,否则选择D列数据。
选项:
A:SELECT CASE WHEN C > A >= B THEN A ELSE D END FROM TABLE_NAME;
B:SELECT CASE WHEN A >= B AND A < C THEN A ELSE D END FROM TABLE_NAME;
C:SELECT CASE WHEN A ≥ B AND A < C THEN A ELSE D END FROM TABLE_NAME;
D:SELECT CASE WHEN C > A ≥ B THEN A ELSE D END FROM TABLE_NAME;
发布时间:2024-06-09 15:02:52