Knowledge Walls
John Peter
Pune, Maharashtra, India
Number and Exponential number rounding issue in Mysql with Example
2036 Views
MySQL Example
SELECT ROUND(4.5),ROUND(-4.5);
# Returns 5 and -5

SELECT ROUND(4.5E0),ROUND(-4.5E0);
# Returns 4 and -4
Output 


Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details