Operand shoshould contain 1 column (s), operandcontain

Source: Internet
Author: User

Operand shoshould contain 1 column (s), operandcontain

This error was found during the SQL test today: Operand shoshould contain 1 column (s ).

The reason is that there are multiple fields behind the in condition, and there can only be one field behind the in condition.


SQL statement error, prompt: "#1241-Operand shoshould contain 1 column (s)" error

The subquery in the right brace of the IN predicate can only output one field, but your subquery uses the symbol "*". IN this way, the database engine will output all fields IN the es_message table to the brackets on the right of the IN, and of course an error will be reported.

Correction Method: Specify only one field to be compared after the SELECT statement of the subquery.

SQL statement error: Prompt: "#1241-Operand shoshould contain 1 column (s)" error

SELECT * FROM ies_message where msgsendtype = 2
Which columns are queried,
Msgsendtype IN can be followed by only one column.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.