Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

replied

Hi All,

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

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


Thanks,

Rithika

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question