Place only two decimal places in a sqlServer sum function

Asked

Viewed 106 times

-1

I would like to know how to put only two decimal places in the field of the sum.inserir a descrição da imagem aqui

sql-server

  • Avoid including images, it is bad for those who help. Explain your table, show the query you already have, and doubt. So it is much better.

1 answer

1


Try it like this:

SELECT ROUND(SUM(valorcobrado),2) FROM vendasservicos

Reading on the ROUND.

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.