Skip to Content

Single row query returns multiple lines

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 15, 2015 at 11:09 AM

    Hi All,

    Solved the issue myself.  I have used werks = (select .... from <table>) instead of

    werks IN (select .... from <table>)


    Thanks,

    Rithika

    Add comment
    10|10000 characters needed characters exceeded