MySQL subquery ERROR CODE 1241 SQLState 21000

Question

I want to retrieve First and Last Row using client_id from my table. So I wrote this which threw an error (1241), Can Anyone please tell me what this issue with this code :

SELECT * 
FROM invoices 
WHERE invoice_id IN (SELECT  MAX(invoice_id), 
                             MIN(invoice_id) 
                     FROM invoices
                     );

WHERE AS this code is perfectly fine :

SELECT * 
FROM invoices 
WHERE invoice_id IN (SELECT  MIN(invoice_id) 
                     FROM invoices 
                     UNION SELECT MAX(invoice_id) 
                     FROM invoices
                    );

Ergest Basha · Accepted Answer · 2022-06-04 12:56:43Z

1

So I wrote this which threw an error (1241), Can Anyone please tell me what this issue with this code :

The error MySQL error 1241: Operand should contain 1 column(s) occurred because the following query

SELECT  MAX(invoice_id), MIN(invoice_id) FROM invoices

returns two columns, not two values. In the where condition you have one column declared WHERE invoice_id IN.

answered Jun 4, 2022 at 12:56

Ergest Basha

9,3164 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL subquery ERROR CODE 1241 SQLState 21000

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related