By 25/02/2016 1 Comments

What Is ROUND() Function In SQL?

  • SQL ROUND() function rounds a numeric column┬áto the number of specified decimals/frictional points in database.

Syntax:

SELECT ROUND(column,decimals) FROM table_name;

SELECT id, product_name, ROUND(price,1) AS "Price"
FROM products;
  • In above query example the ROUND() function returns one zero (0) with each values of price column in table (products).






Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .