Skip to Content
0
Jul 15, 2015 at 09:55 AM

Single row query returns multiple lines

3368 Views

Hi ,

I am getting below error when calling a procedure in HANA Studio SQL editor

single-row query returns more than one row exception: single-row query returns more than one row: Please check lines: 250


Below is the query

SELECT

ARTICLE,

sum(stock_on_hand) as stock_on_hand

FROM :VAR_OUT1

group by ARTICLE;

What will be the reason?

Thanks,

Rithika