Skip to Content

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

how to keep decimal in sql query

Dear Expert,

I try to do calculation in sql query, but it will automatically remove the decimal point.

This is my query:

SELECT 719 / 100

And i want a result = 7.19, but its not work. Its return 7.

i did try to use, SELECT ROUND(719/100,2), but its not working too...

Does any one have any idea how to get 7.19

Thanks in advance for any reply.

Regards,

Mat

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