Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » Operator RSS Feeds

>= ( Greater Than or Equal To ) Comparison Operator

Posted By: Sarita Patel     Category: SQL Server     Views: 12647

This article describes use of >= ( Greater Than or Equal To ) comparison operator with different examples.

Greater than or Equal to operator compares two expressions. When you compare two nonnull expression and left hand operand is greater than or equal to right hand operator then the result is TRUE and right hand operand is greater than or equal to left hand operand then result is FALSE. When you set ANSI_NULLS  ON and any of the expressions are null then the result is null. When you set ANSI_NULLS OFF and any of the expressions are null then the result set is FALSE. But if both expressions are null then the result set is TRUE.

 

 

Syntax of >= ( Greater Than or Equal To ) Comparison Operator :

expression >= expression

 

Where expression is any valid sql expression. Both expression must have implicitly convertible data types. Greater than or Equal to operator returns boolean value TRUE or FALSE. 

  

 

Examples of >= ( Greater Than or Equal To ) Comparison Operator :

Example 1 : Using >= operator in where clause

SELECT ProductName,UnitPrice

FROM products

WHERE unitprice >= 18.00

 

Output

ProductName                                  UnitPrice

Chai                                                   18.00

Chang                                                19.00

Chef Anton's Cajun Seasoning         22.00

Chef Anton's Gumbo Mix               21.35

Grandma's Boysenberry Spread      25.00

Uncle Bob's Organic Dried Pears   30.00 

 

Above query displays rows having UnitPrice greater than or equal to $18.

  

 

Example 2 : Use of greater than or equal to operator to compare variables in select query

DECLARE @Unit1 INT, @Unit2 INT 

SET @Unit1 = 20

SET @Unit2 = 20

 

SELECT Message =

              CASE 

                        WHEN @Unit1 >= @Unit2 THEN 'Unit1 is greater than or equal to Unit2.'

                        ELSE 'Unit1 is less than Unit2.'

              END

  

Output

Message

Unit1 is greater than or equal to Unit2.

  

Above example describes use of greater than or equal to comparison operator in sql query. We can use greater than or equal to operator in select query to compare variable or fields of table.

  

 

Example 3 :  Use of greater than or equal to operator to compare values of table fields in select query

SELECT ProfitPerProduct =

              CASE 

                       WHEN SoldPrice >= ActualPrice THEN '$' + CONVERT(VARCHAR, (SoldPrice                                                                                      - ActualPrice)) +  ' profit on ' + ProductName

                       ELSE  '$' + CONVERT(VARCHAR, (ActualPrice - SoldPrice))  +  ' loss on ' +                                                                                                 ProductName

              END

FROM Products

 

Output

ProfitPerProduct 

$21 profit on Chai

$2 loss on Chang

$3 profit on Aniseed Syrup

$31 profit on Chef Anton's Cajun Seasoning

$21.35 loss on Chef Anton's Gumbo Mix

 

Above example describes use of greater than or equal to operator to compare SoldPrice and ActualPrice field values of table. 

 

 

Example 4 : Comparing value of two variables

DECLARE @Unit1 INT, @Unit2 int 

SET @Unit1 = 20

SET @Unit2 = 10

 

IF(@Unit1 >= @Unit2)  

BEGIN

           PRINT 'Unit1 is greater than or equal to Unit2.'

END

ELSE

BEGIN

           PRINT 'Unit1 is less than Unit2.'

END

 

Output

Unit1 is greater than or equal to Unit2.

 

Above example explains use of greater than or equal to comparison operator to compare two variables. 

 

  
Share: 


Didn't find what you were looking for? Find more on >= ( Greater Than or Equal To ) Comparison Operator Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of >= ( Greater Than or Equal To ) Comparison Operator is from United States.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!