Rounding off to two decimal places in SQL

by

You could cast your result as numeric(x,2). Where x <= 38.

select
    round(630/60.0,2),
    cast(round(630/60.0,2) as numeric(36,2))

Returns

10.500000    10.50

More Related Contents:

  1. Truncate (not round) decimal places in SQL Server
  2. Discard millisecond part from timestamp
  3. Why does SQL Server round off results of dividing two integers?
  4. I dont know sql syntax for my table [closed]
  5. Get top 1 row of each group
  6. How to cast the DateTime to Time
  7. Why is SQL Server losing a millisecond?
  8. Find a string by searching all tables in SQL Server
  9. Database Design for Revisions?
  10. Is there a way to define a named constant in a PostgreSQL query?
  11. How to assign an exec result to a sql variable?
  12. SQL ROWNUM how to return rows between a specific range
  13. Difference between Top and Limit Keyword in SQL
  14. Delete sql rows where IDs do not have a match from another table
  15. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0
  16. Mysql: how to select groups having certain values?
  17. Slow simple update query on PostgreSQL database with 3 million rows
  18. Return setof record (virtual table) from function
  19. Given an RGB value what would be the best way to find the closest match in the database?
  20. How to export image field to file?
  21. Move SQL data from one table to another
  22. PARTITION BY with and without KEEP in Oracle
  23. Stored procedure that exports data into csv files only exports to one file
  24. Get Start and End Date from Week Number SQL Server
  25. Nested select statement in SQL Server
  26. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  27. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  28. COALESCE Function in TSQL
  29. SQL Sort Order with Null values last
  30. SQLite query, ‘LIKE’

Leave a Comment