SQL & PL/SQL

Hi everyone,

I am using the Query shown below to retrieve records. The value obtained in the column Calcluated_value should be the same as Required_value which is a column I have added here to the putput for comparing this with the front end screen of the application, how can I modify my query so that it shows the calculated_value to be the same as the front end values which I have shown here in Required_value column.

Thanks

IQ

Query:-

select distinct

AccountSerial,a."Rec ID",

a."Enc Reading", ,

STR from dual(CAST(a."Enc Reading" AS NUMBER(18,0))/1000,LENGTH(RTRIM(a."Enc Reading"))+2,3 ) "Calculated Value",

-- Required_value are the values obtained from Front-end GUI application

from "Enc Reading Trans" a,

"Account Enc Xref" b

where a."Rec ID" = b."Rec ID"

and CONVERT(date, a."Reading Time") between '2017-01-06' and '2017-01-06'

and ISNUMERIC("Enc Reading") = 1 and AccountSerial in(101761,125293,505832,662847,183716,143976)

order by AccountSerial desc

Output:-