Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

> (Greater Than) (Transact-SQL)

Compares two expressions (a comparison operator) in SQL Server 2012. When you compare nonnull expressions, the result is TRUE if the left operand has a value higher than the right operand; otherwise, the result is FALSE. If either or both operands are NULL, see the topic SET ANSI_NULLS (Transact-SQL).

Topic link icon Transact-SQL Syntax Conventions

expression > expression
expression

Is any valid expression. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.

A. Using > in a simple query

The following example returns all rows in the HumanResources.Department table that have a value in DepartmentID that is greater than the value 13.

USE AdventureWorks2012;
GO
SELECT DepartmentID, Name
FROM HumanResources.Department
WHERE DepartmentID > 13
ORDER BY DepartmentID;

Here is the result set.

DepartmentID Name
------------ --------------------------------------------------
14           Facilities and Maintenance
15           Shipping and Receiving
16           Executive

(3 row(s) affected)

B. Using > to compare two variables

DECLARE @a int = 45, @b int = 40;
SELECT IIF ( @a > @b, 'TRUE', 'FALSE' ) AS Result;

Here is the result set.

Result
------
TRUE

(1 row(s) affected)
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.