SQL Server - Greater than (>) Operator
The SQL Server (Transact-SQL) > (greater than) operator checks if the value of left operand is greater than the value of right operand and returns true if the condition is true, false otherwise.
Syntax
The syntax for using greater than operator in SQL Server (Transact-SQL) is given below:
expression > expression
Parameters
expression |
Any valid expression. Both expressions must have implicitly convertible data types. |
Example:
Consider a database table called Employee with the following records:
| EmpID | Name | City | Age | Salary |
|---|---|---|---|---|
| 1 | John | London | 25 | 3000 |
| 2 | Marry | New York | 24 | 2750 |
| 3 | Jo | Paris | 27 | 2800 |
| 4 | Kim | Amsterdam | 30 | 3100 |
| 5 | Ramesh | New Delhi | 28 | 3000 |
| 6 | Huang | Beijing | 28 | 2800 |
To select records of table where Age of the person is greater than 27, the query is given below.
SELECT * FROM Employee WHERE Age > 27;
The query will produce following result:
| EmpID | Name | City | Age | Salary |
|---|---|---|---|---|
| 4 | Kim | Amsterdam | 30 | 3100 |
| 5 | Ramesh | New Delhi | 28 | 3000 |
| 6 | Huang | Beijing | 28 | 2800 |
❮ SQL Server Operators
