SQL ANY,ALL Operators – Free SQL Tutorials
SQL ANY/ALL Introduction: SQL ANY,ALL are logical operators in structured query language. SQL ANY,ALL returns the Boolean type . SQL ANY, ALL logical operators are used with ‘WHERE’ clause or ‘HAVING’ statement. Important: SQL ALL operators are used when all sub-query meets the required condition. SQL ALL operators are used with ‘SELECT’, ‘HAVING’,’WHERE’ clauses. Both …