Download to read offline
Uploaded byVivek Singh
396 views
Sql operators comparision & logical operators
SQL operators include comparison operators like equals, not equals, less than, and greater than, which are used to filter data in the WHERE and HAVING clauses by comparing column values to specific values. Logical operators include AND, OR, and NOT, and are used to combine multiple comparison expressions in a condition. Comparison operators can also be used with the SELECT statement to filter the returned data.
More Related Content
What's hot
Viewers also liked
Similar to Sql operators comparision & logical operators
More from Vivek Singh
Recently uploaded
Sql operators comparision & logical operators
- 1. 8/10/13 SQL Operators- Comparision & Logical Operators beginner-sql-tutorial.com/sql-operators.htm 1/1 SQL Operators There are two type of Operators, namely Comparison Operators and Logical Operators. These operators are used mainly in the WHERE clause, HAVING clause to filter the data to be selected. Comparison Operators: Comparison operators are used to compare the column data with specific values in a condition. Comparison Operators are also used along with the SELECT statement to filter data based on specific conditions. The below table describes each comparison operator. Comparison Operators Description = equal to <>, != is not equal to < less than > greater than >= greater than or equal to <= less than or equal to Logical Operators: There are three Logical Operators namely AND, OR and NOT. Logical operators are discussed in detail in the next section,Logical Operators