Which function is used to find the largest integer less than or equal to a specific value?

 Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 3481


Floor is used to round a number down to the last whole number. Any number with even the highest decimal is rounded down.

  SELECT FLOOR(-5.12); 

This will be round down to -6
  SELECT FLOOR(5.14); 

This will be round down to 5

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Prasad_N on: 1/5/2012 | Points: 10
Thanks ..for info..

The CEILING function will do the reverse


SELECT CEILING(-5.12); - Returns : -5

SELECT CEILING(5.14); -- Returns : 6

Login to post response