can anyone help me with my query...in my current query i calculate the average of the total score of a specific person and the out is like 4.232398 i want it to round of automatically the final score so that is not decimal type output....can anyone help me with that.
my query:
SELECT DISTINCT
(SELECT SUM(t2.inttotal)
FROM app_interview2 AS t2
WHERE t2.atic = t.atic)/7
AS interview_sum,
(SELECT SUM(o2.ototal)
FROM other_app2 AS o2
WHERE o2.oaic = t.atic)/7
AS other_sum,
atid,
atic,
atname,
region,
town,
uniq_id,
position,
salary_grade,
salary
FROM app_interview2 AS t
WHERE uniq_id = '$q'
GROUP BY t.atname HAVING COUNT(DISTINCT t.atic)
