Using ROUND(x) generates ERROR 1241: Operand should contain 1 column(s)
Posted on 2005-04-06
I am getting the below error when using the below query. What do I need to change in my query? This error started taking place when I added the ROUND() function which I added so that the math would round out to two decimal places instaed of the existing four places e.g. $234.3456 and I want it to be $234.35.
ERROR 1241: Operand should contain 1 column(s)
SELECT DISTINCT account_name, COUNT(return_code), CONCAT('$',SUM(check_amount)), CONCAT((ROUND(SUM(check_amount)/23456)*100,2), '%') AS 'Rank' FROM `bcf_collections` WHERE (locate('296',pcid)>0 OR locate('---',account_name)>0) AND pos_date BETWEEN '2005-03-06' AND '2005-04-06' GROUP BY account_name ORDER BY 'Rank'DESC ;