1
Download SQL Users` Manual - ALTIBASE Customer Support
Transcript
Simple Comparison Conditions Simple Comparison Conditions Syntax simple_comparison_condition ::= = != <> expr expr > subquery ( ) < >= <= = ( expr , ) != ( subquery ) <> Description Comparison is made according to the comparison operator. Two conditions on both sides will be compared, and the comparison result will be displayed. Conditional clause to compare the size and the state of two expressions on both sides. If there are two or more expressions on the left, the number of expressions on the left and the number of expressions of the subquery target list must be the same. The result of the subquery on the right must be one record. 400 SQL Conditions
