Define operators in SQL. List any four relational operators with examples.

Question

Accepted Answer

Operators in SQL are special symbols or keywords used to perform operations on values or expressions, mostly used in WHERE clauses and conditions. Four relational operators: (i) = — checks equality, e.g., WHERE City = 'Pokhara'; (ii) != — checks not equal, e.g., WHERE City != 'Pokhara'; (iii) — greater than, e.g., WHERE Age 15; (iv) BETWEEN — checks a range, e.g., WHERE Age BETWEEN 14 AND 16.