Hi,
I need to divide two subqueries and please let me know how to do it.
Actually i used the select ......... from dual for each subquery for addition and subtraction and it worked .
the same way for division is not working.
Please suggest the various ways for doing this.
select
(SELECT
(z.NEW_UPTO_THE_MONTH + z.RENEW_UPTO_THE_MONTH
+ z.AE_UPTO_THE_MONTH + z.RE_UPTO_THE_MONTH) as Premium_Upto_the_period
FROM CONSOL_GDPI1_UPTO)
as premium from dual
[\code]
[pre]
this throws an error tha tsingle row subquery return more than one row.
actually this needs to be my denominator to perform the division operation .
[\pre]