We will use our student table and get the rounded data by using round query.
Percentage is a column name in our student table. Here we store the percentage value of each student mark. One of our student Max has got 79.2982 percentage. This number we can round off and display without any decimal value by using command like this.
SELECT name,percentage,round(percentage,0) as rnd FROM `student4`
Inside round function we can change the number of decimal places required to 1,2,3 etc .. here is an example.
SELECT name,percentage,round(percentage,2) as rnd FROM `student4`