Operators in sql server

Operators in SQL server.

How to use operators in SQL Server: Operator is very useful in SQL Server. It is used to filter records while manipulation in SQL database. The SQL operator used with SQL "Select where command". The operator helps to display records base on user need. For example, display records base on specific country.

SQL Server  Operators:

Sn.	Operators	Operator Name	Syntax	Example
1.	=	Equal to	Select */column_name...Where column_name='value'	Select * from ItemDetails Where Quantity='500'
2.	>	Greater than	Select */column_name...Where column_name>'value'	Select * from ItemDetails Where Quantity>'500'
3.	>=	Greater than	Select */column_name...Where column_name>='value'	Select * from ItemDetails Where Quantity>='500'
4.	<	Greater than	Select */column_name...Where column_name<'value'	Select * from ItemDetails Where Quantity<'500'
5.	<=	Greater than	Select */column_name...Where column_name<='value'	Select * from ItemDetails Where Quantity<='500'