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: 5523

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

FLOOR

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

Examples:

  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

Bookmark It

< Previous : What is the use of DESC in SQL?

Next > : What is the type of the algorithm used in solving ...

Comments or Responses

Posted by: Prasad_N on: 1/5/2012 | Points: 10

Thanks ..for info..

The CEILING function will do the reverse

i.e

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

SELECT CEILING(5.14); -- Returns : 6

More Interview Questions by Abhisek

What is the type of the algorithm used in solving the 8 Queens problem ...
When TimerCallback delegate is used?
Which namespace is used to create a multi-threaded application?
Which enumeration defines different PenCap in C#?
What is the use of param keyword in C#?
Which class defines different events for controls in C#?
What are the different states in ASP.NET?
What is the use of profiles in ASP.NET?

Latest Interview Questions

Can you compare two SQL fields with datatype "text" by using ...
what is web part?and type
what is MOSS ?
What are ways to create input forms for workflow ?
What are the types of input forms that can be created for a workflow ?
What is Authentication and Authorization.
what is Ajax?
what is PrePageExecute() event
More ...