Result consisted of more than row error in mysql

Example:



One of the "select into" statements is returning more than one result.
Example:

SELECT   @NetBalance + TH.ClosingBalance INTO @NetBalance
    FROM TransactionHead;

Answer:

You can limit the Query.

SELECT   @NetBalance + TH.ClosingBalance INTO @NetBalance
    FROM TransactionHead Limit 1;

Problem solved...