本文共 894 字，大约阅读时间需要 2 分钟。

题目：（中等）

标签：SQL

解法一：

SELECT left_operand,       operator,       right_operand,       CASE           WHEN operator = '>' THEN               IF((SELECT value FROM Variables WHERE name = E.left_operand)                      >                  (SELECT value FROM Variables WHERE name = E.right_operand), 'true', 'false')           WHEN operator = '=' THEN               IF((SELECT value FROM Variables WHERE name = E.left_operand)                      =                  (SELECT value FROM Variables WHERE name = E.right_operand), 'true', 'false')           WHEN operator = '<' THEN               IF((SELECT value FROM Variables WHERE name = E.left_operand)                      <                  (SELECT value FROM Variables WHERE name = E.right_operand), 'true', 'false')           END AS valueFROM Expressions AS E;

转载地址：https://dataartist.blog.csdn.net/article/details/110424480 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！