Shulou(Shulou.com)06/01 Report--

SELECT ROUND (3.14); # rounded SELECT ROUND (3.1415); # the second parameter is the number of digits reserved for the decimal point SELECT CEIL (1.2); # the smallest integer SELECT FLOOR greater than 1.2 (1.2); # the largest integer SELECT TRUNCATE less than 1.2 (3.1415 SELECT TRUNCATE 2); # 2 digits after the decimal point, and the rest truncated SELECT MOD (10% 3); # the remainder SELECT 10% 3 / / returns the decimal between 0 and 1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.