{"id":21774,"date":"2018-08-07T04:00:16","date_gmt":"2018-08-07T04:00:16","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=21774"},"modified":"2021-03-10T11:35:16","modified_gmt":"2021-03-10T06:05:16","slug":"sql-operators","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sql-operators\/","title":{"rendered":"SQL Operators with Syntax and Examples"},"content":{"rendered":"<p>We will discuss SQL(Structured Query Language) operators in this article.<\/p>\n<p>In SQL, we have multiple types of operators available, which we will be discussing shortly. We use SQL operators to specify conditions and statements, satisfying a query of desired data output.<\/p>\n<h3>What is SQL Operator?<\/h3>\n<p>An operator is a reserved character or word which is used in a SQL statement to query our database. We use a WHERE clause to query a database using operators.<\/p>\n<p>Operators are needed to specify conditions in a SQL statement. The available operators act as a connector for various conditional statements.<\/p>\n<h3>Types of SQL Operators<\/h3>\n<p>We have various SQL operators, and they are as follows:<\/p>\n<ul>\n<li>SQL Arithmetic operators<\/li>\n<li>SQL Comparison operators<\/li>\n<li>SQL Logical operators<\/li>\n<li>SQL Compound Operators<\/li>\n<li>SQL Bitwise Operators<\/li>\n<li>SQL Unary Operator<\/li>\n<\/ul>\n<h3>Demo Database<\/h3>\n<p>Let us first view our database, which we will use in this tutorial; we will be using a database of DataFlair employees and their details. Our database is as follows :<\/p>\n<p><strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM DataFlair_Employee ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86781\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database.png\" alt=\"SQL Demo database\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/demo-database-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>This is what our database looks like. Let\u2019s get ahead and learn about SQL operators.<\/p>\n<h3>SQL Arithmetic Operators<\/h3>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT column1+column2(airthmetic operation on columns),\r\ncolumn2*column3 (airthmetic operation on columns),\r\n\u2026\u2026\r\nFROM tableName;\r\n<\/pre>\n<p>These are basic day-to-day operators used in SQL queries. All the arithmetic operators are shown in the table below:<\/p>\n<table style=\"height: 368px;\" width=\"793\">\n<tbody>\n<tr>\n<td><b>Sr.No<\/b><\/td>\n<td><b>Arithmetic Operators<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">+<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Add<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">&#8211;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Subtract<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><span style=\"font-weight: 400;\">*<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Multiply<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\/<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Division<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">5<\/span><\/td>\n<td><span style=\"font-weight: 400;\">%<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Modulo<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Example 1: <\/strong>Let us check if we double the Salaries of our employees at DataFlair using the SQL query.<br \/>\n<strong>Solution 1:<\/strong> Using the addition operator.<br \/>\n<strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT name_emp, salary+salary as Double_Salary FROM DataFlair_Employee ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86782\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1.png\" alt=\"airthmetic operators example 1\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operators-example-1-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>We can clearly see what would be the salary if we double the salary of the DataFlair employees.<\/p>\n<p><strong>Solution 2:<\/strong> Using the multiplication operator.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT name_emp, salary*2 as Double_Salary FROM DataFlair_Employee ;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86783\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2.png\" alt=\"airthmetic operator example 2\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/airthmetic-operator-example-2-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>We can clearly see what would be the salary if we double the salary of the DataFlair employees.<\/p>\n<h3>SQL Comparison Operators<\/h3>\n<table style=\"height: 615px;\" width=\"766\">\n<tbody>\n<tr>\n<td><b>Sr.No<\/b><\/td>\n<td><b>Comparison Operators<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><b>=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Equal<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><b>&gt;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Greater than<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><b>&lt;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Smaller than<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><b>&gt;=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Greater than Equal to<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">5<\/span><\/td>\n<td><b>&lt;=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Smaller than Equal to<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<td><b>!&lt;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Not less than<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<td><b>!=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Not Equal to<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<td><b>! &gt;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Not greater than<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">9<\/span><\/td>\n<td><b>&lt; &gt;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Value equal to<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Syntax of SQL Comparison Operators:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT column1&gt;column2(comparisons ofcolumns),\r\ncolumn2&lt;column3 (comparisons of columns),\r\n\u2026\u2026\r\nFROM tableName;\r\n\r\n<\/pre>\n<p><strong>Example 1:<\/strong> Let us view employees with a salary of less than 20,000.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT name_emp, salary FROM DataFlair_Employee where salary&lt;20000;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86784\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1.png\" alt=\"SQL Comparison Operators Example\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Comparison-operators-example-1-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>We can observe the employees with a salary of less than 20,000 in DataFlair.<\/p>\n<p><strong>Example 2:<\/strong> Let us view the details of employees whose age is more than or equal to 25.<br \/>\n<strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM DataFlair_Employee where age &gt;= 25 ;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86785\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2.png\" alt=\"SQL comparison operator example 2\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/comparison-operator-example-2-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>SQL Compound Operators<\/h3>\n<p>SQL compound operators are as shown below in the following table:<\/p>\n<table style=\"height: 565px;\" width=\"766\">\n<tbody>\n<tr>\n<td><b>Sr.No<\/b><\/td>\n<td><b>Compound Operators<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><b>+=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Add equals<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><b>-=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Subtract equals<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><b>*=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Multiply equals<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><b>\/=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Divide equals<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">5<\/span><\/td>\n<td><b>%=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Modulo equals<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<td><b>&amp;=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Bitwise AND equals<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<td><b>^-=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Bitwise Exclusive equals<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<td><b>|*=<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Bitwise exclusive OR equals<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Syntax of Compound Operators in SQL:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT column1+=column2 (compound operations on columns),\r\ncolumn2*=column3 (compound operations on columns),\r\n\u2026\u2026\r\nFROM tableName;\r\n<\/pre>\n<p><strong>Example:<\/strong> Let us increment the age of each employee with 10.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select (age+=10) from dataflair ;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86786\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator.png\" alt=\"example of SQL compound operator\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-compound-operator-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>SQL Logical Operators<\/h3>\n<p>SQL provides us with many logical operators to use while querying a database. All the logical operators are listed below in the table:<\/p>\n<table style=\"height: 804px;\" width=\"753\">\n<tbody>\n<tr>\n<td><b>Sr.No<\/b><\/td>\n<td><b>SQL Logical Operators<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">ALL<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE when all subqueries are satisfied<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">AND<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE if all conditions in AND are satisfied<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><span style=\"font-weight: 400;\">ANY<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE if any subquery is satisfied<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><span style=\"font-weight: 400;\">BETWEEN<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE if the operand is in the given range<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">5<\/span><\/td>\n<td><span style=\"font-weight: 400;\">EXISTS<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns true if one or more data record exists<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<td><span style=\"font-weight: 400;\">IN<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE if data matches the list of conditions<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<td><span style=\"font-weight: 400;\">LIKE<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE if our operand is similar to a pattern<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">8<\/span><\/td>\n<td><span style=\"font-weight: 400;\">NOT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns records if the condition is not satisfied<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">9<\/span><\/td>\n<td><span style=\"font-weight: 400;\">OR<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE if any one of all subqueries is satisfied<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">10<\/span><\/td>\n<td><span style=\"font-weight: 400;\">SOME<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns TRUE if any of our subqueries is satisfied.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">11<\/span><\/td>\n<td><span style=\"font-weight: 400;\">IS NULL<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Used to compare the NULL values.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">12<\/span><\/td>\n<td><span style=\"font-weight: 400;\">UNIQUE<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns rows that are unique.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Syntax of Logical Operators in SQL:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT column1,\r\nColumn2,\r\ncolumn3,\r\n\u2026\u2026\r\nFROM tableName\r\nWHERE logical condition ;\r\n<\/pre>\n<p><strong>Example 1:<\/strong> Let us find employees whose age is greater than 27 and salary is greater than 25,000.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT name_emp,salary, age  FROM DataFlair_Employee WHERE age&gt;27 AND salary&gt;25000;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86787\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1.png\" alt=\"SQL logical operators example 1\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-1-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>Example 2:<\/strong> Let us find employees whose salary is less than 25 or the salary is more than 27,000.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT name_emp,salary, age  FROM DataFlair_Employee WHERE age&lt;25 OR salary&gt;27000;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86788\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2.png\" alt=\"SQL logical operators example 2\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/logical-operators-example-2-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>SQL Unary Operators<\/h3>\n<p>SQL unary operators operate in a single operand and can be used on any numeric datatype. SQL unary operators are as follows:<\/p>\n<table style=\"height: 190px;\" width=\"766\">\n<tbody>\n<tr>\n<td><b>Sr.No<\/b><\/td>\n<td><b>Unary Operators in SQL<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">(-)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns the negative value of the passed expression.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">(+)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Returns the positive value of the passed expression.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Syntax of SQL Unary Operators:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT -(col1),+(col2), ... FROM tablename;\r\n<\/pre>\n<p><strong>Example:<\/strong><br \/>\nLet us find the -ve age of Siya.<br \/>\n<strong>Query:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select -(age) as negAge from dataflair where name ='Siya';\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86789\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator.png\" alt=\"example of SQL unary operator\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-unary-operator-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>SQL Bitwise Operators<\/h3>\n<p>SQL bitwise operators are as below shown in the table:<\/p>\n<table style=\"height: 373px;\" width=\"752\">\n<tbody>\n<tr>\n<td><b>Sr.No<\/b><\/td>\n<td><b>Bitwise Operators in SQL<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><b>&amp;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Bitwise AND<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><b>|<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Bitwise OR<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><b>^<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Bitwise exclusive OR<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><b>&lt;&lt;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Left Shift<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">5<\/span><\/td>\n<td><b>&gt;&gt;<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Right Shift<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Syntax of Bitwise Operators in SQL:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT (col1 &amp; num1), (col2 | num2), \u2026.. FROM tableName;\r\n<\/pre>\n<p><strong>Example:<\/strong> Let us find the &amp; of employees age from 10.<br \/>\n<strong>Query:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select (age &amp; 10) from dataflair ;\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86790\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator.png\" alt=\"example of bitwise operator in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/example-of-binary-operator-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>Summary<\/h3>\n<p>We have discussed and analyzed how to use various SQL operators in queries, to get the desired output data as required by the user.<\/p>\n<p>SQL operators come in handy when we need to cleanse and prepare data for data analysis. We use queries to transact data when a user asks for data that satisfies some conditions.<\/p>\n<p>Operators make it easy for us to obtain the required data values from the database in the most efficient and orderly method from the database records.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will discuss SQL(Structured Query Language) operators in this article. In SQL, we have multiple types of operators available, which we will be discussing shortly. We use SQL operators to specify conditions and statements,&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":86791,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[2780,13408,23826,13496,13505,13506,23827,15499],"class_list":["post-21774","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-comparison-operators-in-sql","tag-sql-arithmetic-operators","tag-sql-bitwise-operators","tag-sql-logical-operators","tag-sql-operators","tag-sql-operators-examples","tag-sql-unary-operators","tag-what-are-sql-operators"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Operators with Syntax and Examples - DataFlair<\/title>\n<meta name=\"description\" content=\"SQL Operators-comparison operators in SQL, arithmetic operator,logical Operator,bitwise operators etc with example &amp; syntax\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sql-operators\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Operators with Syntax and Examples - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SQL Operators-comparison operators in SQL, arithmetic operator,logical Operator,bitwise operators etc with example &amp; syntax\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sql-operators\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-07T04:00:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-10T06:05:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Operators.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Operators with Syntax and Examples - DataFlair","description":"SQL Operators-comparison operators in SQL, arithmetic operator,logical Operator,bitwise operators etc with example & syntax","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/sql-operators\/","og_locale":"en_US","og_type":"article","og_title":"SQL Operators with Syntax and Examples - DataFlair","og_description":"SQL Operators-comparison operators in SQL, arithmetic operator,logical Operator,bitwise operators etc with example & syntax","og_url":"https:\/\/data-flair.training\/blogs\/sql-operators\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-07T04:00:16+00:00","article_modified_time":"2021-03-10T06:05:16+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Operators.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SQL Operators with Syntax and Examples","datePublished":"2018-08-07T04:00:16+00:00","dateModified":"2021-03-10T06:05:16+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/"},"wordCount":814,"commentCount":3,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Operators.jpg","keywords":["comparison operators in SQL","SQL arithmetic operators","SQL Bitwise Operators","sql logical operators","SQL Operators","SQL operators examples","SQL Unary Operators","what are SQL operators"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sql-operators\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/","url":"https:\/\/data-flair.training\/blogs\/sql-operators\/","name":"SQL Operators with Syntax and Examples - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Operators.jpg","datePublished":"2018-08-07T04:00:16+00:00","dateModified":"2021-03-10T06:05:16+00:00","description":"SQL Operators-comparison operators in SQL, arithmetic operator,logical Operator,bitwise operators etc with example & syntax","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sql-operators\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Operators.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Types-of-SQL-Operators.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sql-operators\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Searching for Groups of Scala Regex","item":"https:\/\/data-flair.training\/blogs\/tag\/searching-for-groups-of-scala-regex\/"},{"@type":"ListItem","position":3,"name":"SQL Operators with Syntax and Examples"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=21774"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21774\/revisions"}],"predecessor-version":[{"id":86792,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/21774\/revisions\/86792"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/86791"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=21774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=21774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=21774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}