Below is my simple query:
from openquery (district,' select invoiceid,
case when custcode = 'red' then round(invoiceid/5,1) else 0 end as invoice2
oradb is oracle table in oracle database
In Oracle side, I am returning decimal value but in sql I am not returning decimal value. How do I update this simple query to fix this issue so I can return the value in decimal as well?
Thank you SQL expert!