How can i resolve 'operand should contain 1 column(s)' in sql?
Example:
SELECT * FROM users WHERE (id, name) = (1);
This error indicates that the left-hand side has multiple columns, while the right-hand side has a single value.
Solution:Ensure that both sides of the operand have the same number of columns.
SELECT * FROM users WHERE id = 1;