SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Compact Edition Books Online
SQL Server Compact Edition Programming
SQL Reference (SQL Server Compact Edition)
SQL Overview (SQL Server Compact Edition)
+ (Add) (SQL Server Compact Edition)
+ (Positive) (SQL Server Compact Edition)
+ (String Concatenation) (SQL Server Compact Edition)
- (Subtract) (SQL Server Compact Edition)
- (Negative) (SQL Server Compact Edition)
* (Multiply) (SQL Server Compact Edition)
/ (Divide) (SQL Server Compact Edition)
% (Modulo) (SQL Server Compact Edition)
& (Bitwise AND) (SQL Server Compact Edition)
| (Bitwise OR) (SQL Server Compact Edition)
^ (Bitwise Exclusive OR) (SQL Server Compact Edition)
~ (Bitwise NOT) (SQL Server Compact Edition)
= (Equals) (SQL Server Compact Edition)
> (Greater Than) (SQL Server Compact Edition)
< (Less Than) (SQL Server Compact Edition)
>= (Greater Than or Equal To) (SQL Server Compact Edition)
<= (Less Than or Equal To) (SQL Server Compact Edition)
<> (Not Equal To) (SQL Server Compact Edition)
!= (Not Equal To) (SQL Server Compact Edition)
!< (Not Less Than) (SQL Server Compact Edition)
!> (Not Greater Than) (SQL Server Compact Edition)
@@IDENTITY (SQL Server Compact Edition)
ABS (SQL Server Compact Edition)
ACOS (SQL Server Compact Edition)
ALL (SQL Server Compact Edition)
ALTER TABLE (SQL Server Compact Edition)
AND (SQL Server Compact Edition)
ASIN (SQL Server Compact Edition)
ATAN (SQL Server Compact Edition)
ATN2 (SQL Server Compact Edition)
AVG (SQL Server Compact Edition)
BETWEEN (SQL Server Compact Edition)
CASE (SQL Server Compact Edition)
CEILING (SQL Server Compact Edition)
CHARINDEX (SQL Server Compact Edition)
COALESCE (SQL Server Compact Edition)
COLLATE (SQL Server Compact Edition)
CONVERT (SQL Server Compact Edition)
COS (SQL Server Compact Edition)
COT (SQL Server Compact Edition)
COUNT (SQL Server Compact Edition)
CREATE DATABASE (SQL Server Compact Edition)
CREATE INDEX (SQL Server Compact Edition)
CREATE STATISTICS (SQL Server Compact Edition)
CREATE TABLE (SQL Server Compact Edition)
DATALENGTH (SQL Server Compact Edition)
DATEADD (SQL Server Compact Edition)
DATEDIFF (SQL Server Compact Edition)
DATENAME (SQL Server Compact Edition)
DATEPART (SQL Server Compact Edition)
DDL Statements (SQL Server Compact Edition)
DEGREES (SQL Server Compact Edition)
DELETE (SQL Server Compact Edition)
DML Statements (SQL Server Compact Edition)
DROP INDEX (SQL Server Compact Edition)
DROP STATISTICS (SQL Server Compact Edition)
DROP TABLE (SQL Server Compact Edition)
EXISTS (SQL Server Compact Edition)
EXP (SQL Server Compact Edition)
Expressions (SQL Server Compact Edition)
FLOOR (SQL Server Compact Edition)
FROM Clause (SQL Server Compact Edition)
Functions (SQL Server Compact Edition)
GETDATE (SQL Server Compact Edition)
GROUP BY Clause (SQL Server Compact Edition)
HAVING Clause (SQL Server Compact Edition)
Hints (SQL Server Compact Edition)
IDENTITY Property (SQL Server Compact Edition)
IN (SQL Server Compact Edition)
Information Schema (SQL Server Compact Edition)
INSERT (SQL Server Compact Edition)
IS [NOT] NULL (SQL Server Compact Edition)
LEN (SQL Server Compact Edition)
LIKE (SQL Server Compact Edition)
LOG (SQL Server Compact Edition)
LOG10 (SQL Server Compact Edition)
LOWER (SQL Server Compact Edition)
LTRIM (SQL Server Compact Edition)
MAX (SQL Server Compact Edition)
MIN (SQL Server Compact Edition)
NCHAR (SQL Server Compact Edition)
NEWID (SQL Server Compact Edition)
NOT (SQL Server Compact Edition)
Operators (SQL Server Compact Edition)
OR (SQL Server Compact Edition)
ORDER BY Clause (SQL Server Compact Edition)
PATINDEX (SQL Server Compact Edition)
PI (SQL Server Compact Edition)
POWER (SQL Server Compact Edition)
RADIANS (SQL Server Compact Edition)
RAND (SQL Server Compact Edition)
REPLACE (SQL Server Compact Edition)
REPLICATE (SQL Server Compact Edition)
Reserved Words (SQL Server Compact Edition)
ROUND (SQL Server Compact Edition)
RTRIM (SQL Server Compact Edition)
SELECT Statement (SQL Server Compact Edition)
SIGN (SQL Server Compact Edition)
SIN (SQL Server Compact Edition)
SOME | ANY (SQL Server Compact Edition)
sp_show_statistics (SQL Server Compact Edition)
SPACE (SQL Server Compact Edition)
SQRT (SQL Server Compact Edition)
STR (SQL Server Compact Edition)
STUFF (SQL Server Compact Edition)
SUBSTRING (SQL Server Compact Edition)
SUM (SQL Server Compact Edition)
TAN (SQL Server Compact Edition)
UNICODE (SQL Server Compact Edition)
UNION (SQL Server Compact Edition)
UPDATE (SQL Server Compact Edition)
UPDATE STATISTICS (SQL Server Compact Edition)
UPPER (SQL Server Compact Edition)
USE (SQL Server Compact Edition)
WHERE Clause (SQL Server Compact Edition)
Expand Minimize
This topic has not yet been rated - Rate this topic

FLOOR (SQL Server Compact Edition)

SQL Server 2005

Returns the largest integer less than or equal to the given numeric expression.

Copy 

FLOOR (numeric_expression)
numeric_expression

An expression of the exact numeric or approximate numeric data type categories, or of data types that are implicitly convertible to float.

Returns the same type as numeric_expression except for the following expressions.

Specified expression Return type

tinyint, smallint

int

real/float

float

Nonnumeric types that can be implicitly converted to float

float

The following example applies the FLOOR function to the UnitPrice column of the Order Details table.

Copy 
SELECT OrderID, UnitPrice, FLOOR(UnitPrice) AS "Floor Value"
FROM "Order Details"
WHERE UnitPrice > 100
ORDER BY UnitPrice
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.