{"id":46083,"date":"2018-12-21T11:25:30","date_gmt":"2018-12-21T05:55:30","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=46083"},"modified":"2021-03-10T17:57:59","modified_gmt":"2021-03-10T12:27:59","slug":"clause-in-sql","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/","title":{"rendered":"Clause in SQL &#8211; Types with Syntax and Example"},"content":{"rendered":"<p>SQL is a query language which queries and returns the desired data from the database. We use SQL for multiple operations related to data, some of them being viewing the data and analyzing the data.<\/p>\n<p>There are various clauses available in SQL, which help us to work on data easily. We will discuss the following clauses in this tutorial &#8211; where, and, or, like, and many more.<\/p>\n<h3>What are Clauses in SQL?<\/h3>\n<p>Clauses are in-built functions available to us in SQL. With the help of clauses, we can deal with data easily stored in the table.<\/p>\n<p>Clauses help us filter and analyze data quickly. When we have large amounts of data stored in the database, we use Clauses to query and get data required by the user.<\/p>\n<p>Some of the examples of clauses are &#8211; where, and, or, like, top, etc.<\/p>\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<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\/12\/view-database.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86813\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database.png\" alt=\"view database\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/view-database-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>1. Where Clause in SQL<\/h3>\n<p>We use the WHERE clause to specify conditionals in our SQL query. Where clause can be used in the update and delete statements as well as to perform operations on the desired data.<\/p>\n<p><strong>Rules and Usage:<\/strong><br \/>\n1. Rules:<\/p>\n<ul>\n<li>When using a Where clause, we need to mention at least one condition.<\/li>\n<\/ul>\n<p>2. Usage:<\/p>\n<ul>\n<li>Used to query and transact the database.<\/li>\n<li>Used with an update and delete statements to make sure the right data points are deleted.<\/li>\n<\/ul>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM tableName WHERE condition ;<\/pre>\n<p><strong>Example 1:<\/strong> Let us find the details of all employees who earn more than 25,000 and are above 25.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from dataflair_employee WHERE age&gt;25 and salary &gt;25000 ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86814\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example.png\" alt=\"where clause in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/where-example-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here we can see, the details of all employees who earn more than 25,000 and are above 25.<\/p>\n<h3>2. And Clause in SQL<\/h3>\n<p>We use And clause while specifying multiple conditions together in a query with the Where clause.<\/p>\n<p><strong>Rules and Usage:<\/strong><br \/>\n1. Rules:<\/p>\n<ul>\n<li>When using an And clause, we need to mention at least two conditions(the result would satisfy both.)<\/li>\n<\/ul>\n<p>2. Usage:<\/p>\n<ul>\n<li>Used to query and transact the database.<\/li>\n<li>Used with an update and delete statements to make sure the right data points are deleted.<\/li>\n<li>Returns a data point only if all conditions meet the requirements.<\/li>\n<\/ul>\n<p><strong>Syntax:\u00a0<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM tableName WHERE condition1 AND condition2 ;<\/pre>\n<p><strong>Example 1:<\/strong> Let us find the details of employees whose age is between 22 to 28 and earn less than 30,000.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from dataflair_employee where age&gt;22 and age&lt;28 and salary&lt;30000 ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86815\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example.png\" alt=\"and clause in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/and-example-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here, we can see the details of employees whose age is between 22 and 28 and have a salary less than 30,000.<\/p>\n<h3>3. Or Clause in SQL<\/h3>\n<p>Or clause is beneficial when we need to pass multiple conditions, and we need data that satisfies any one of those specified conditions.<\/p>\n<p><strong>Rules and Usage:<\/strong><br \/>\n1. Rules:<\/p>\n<ul>\n<li>When using an Or clause, we need to mention at least two conditions(the result would be at least one of the specified conditions.)<\/li>\n<\/ul>\n<p>2. Usage:<\/p>\n<ul>\n<li>Used while transacting and querying a database.<\/li>\n<li>Used in the update and delete statements.<\/li>\n<li>Or clause returns a data point when any one of the specified conditions is met.<\/li>\n<\/ul>\n<p><b><\/b><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM tableName  WHERE condition1 OR condition2 ;<\/pre>\n<p><strong>Example 1:<\/strong> Let us find the employees with age more than 26 or a salary more than 30000<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from dataflair_employee where salary &gt; 30000 OR age &gt; 26<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86816\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example.png\" alt=\"OR clause in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/or-example-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here, we can see the details of employees with age more than 26 and salary more than 30,000.<\/p>\n<h3>4. Like Clause in SQL<\/h3>\n<p>LIKE clause is beneficial to find specific patterns in the data. We use specific symbols i.e (%) and ( _ ). The rules and usage is specified below.<\/p>\n<p><strong>Rules and Usage:<\/strong><br \/>\n1. Rules:<\/p>\n<ul>\n<li>% &#8211; Represents zero, one, or multiple characters.<\/li>\n<li>_ &#8211; Represents one single character.<\/li>\n<\/ul>\n<p>2. Usage:<\/p>\n<ul>\n<li>Used to retrieve data points that satisfy the pattern passed using the like clause.<\/li>\n<\/ul>\n<p><strong>Syntax :<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM tableName WHERE column2 LIKE pattern ;<\/pre>\n<p><strong>Example 1:<\/strong> Let us find the details of employees whose name starts with A.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from dataflair_employee where name_emp LIKE 'A%' ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86817\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example.png\" alt=\"Like Clause in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/like-example-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here, we can see the details of the employees whose name starts with \u2018A\u2019.<\/p>\n<h3>5. Limit Clause in SQL<\/h3>\n<p>We use the limit clause when we have a large amount of data in the table. With the help of the limit clause, we can restrict the number of rows our query returns.<\/p>\n<p><strong>Rules and Usage:<\/strong><br \/>\n1. Rules:<\/p>\n<ul>\n<li>We need to specify a number after the limit clause.<\/li>\n<li>Float and exponential values can\u2019t be utilized.<\/li>\n<\/ul>\n<p>2. Usage:<\/p>\n<ul>\n<li>Used to limit the data that a query would return.<\/li>\n<\/ul>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM tableName LIMIT number ;<\/pre>\n<p><strong>Example 1:<\/strong> Let us view the first 5 rows of data from our table DataFlair_Employee.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from dataflair_employee limit 5 ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86818\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example.png\" alt=\"Limit Clause in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/limit-example-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here, we can see the first five rows of our table.<\/p>\n<h3>6. Order By Clause in SQL<\/h3>\n<p>We use order by clause to sort data in ascending or descending order as required by the user. By default, the data is sorted in ascending order.<\/p>\n<p><strong>Rules and Usage:<\/strong><br \/>\n1. Rules:<\/p>\n<ul>\n<li>A comparable data column should be passed in the query.<\/li>\n<li>Any column can be used in the order by clause, even those which do not appear in our select statement.<\/li>\n<li>We can sort data in ascending or descending order (by default sorting is done in ascending order).<\/li>\n<\/ul>\n<p>2. Usage:<\/p>\n<ul>\n<li>Order by clause is useful to get data in required sorting orders.<\/li>\n<\/ul>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM tableName ORDER BY column1, column2, ... ASC\/DESC;<\/pre>\n<p><strong>Example 1:<\/strong> Let us view the details of employees ordered in Descending order according to salary.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Select * from dataflair_employee Order by salary desc ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86819\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example.png\" alt=\"Order By Clause in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/order-by-example-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here, we have obtained the details of employees in descending order of salary.<\/p>\n<h3>7. Group By Clause in SQL<\/h3>\n<p>We use order by clause to get the summary of data in rows and is mostly taken in usage with the aggregate functions like Count, Sum, etc.<\/p>\n<p><strong>Rules and Usage:<\/strong><br \/>\n1. Rules:<\/p>\n<ul>\n<li>Columns appearing in the Select clause can only be taken care of in the Group By clause.<\/li>\n<li>Columns we are passing to the Group By clause should be of comparable type.<\/li>\n<\/ul>\n<p>2. Usage:<\/p>\n<ul>\n<li>We use Group by clause to get the groups present in data.<\/li>\n<\/ul>\n<p><strong>Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT * FROM table_name WHERE condition GROUP BY column1 ;<\/pre>\n<p><strong>Example 1:<\/strong> Let us count the employees with each age.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT COUNT(age), age FROM dataflair_employee GROUP BY age ;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-86820\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example.png\" alt=\"Group By Clause in SQL\" width=\"1920\" height=\"1030\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-300x161.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-1024x549.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-768x412.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-1536x824.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-720x386.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-520x279.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/group-by-example-320x172.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Here, we have generated a count of the number of employees of each age in our organisation.<\/p>\n<h3>Summary<\/h3>\n<p>We have discussed various clauses and their utilities. SQL clauses are beneficial as they simplify our queries and help us to get data quickly and efficiently.<\/p>\n<p>With the use of clauses, we can get data in patterns, groups, and ordered format as well.<\/p>\n<p>When we use the clause available, we can get rid of extra complexities arising in queries due to large formulas or large sets of data. This also helps us to increase the efficiency of our queries and the return time of the query.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL is a query language which queries and returns the desired data from the database. We use SQL for multiple operations related to data, some of them being viewing the data and analyzing the&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":86821,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[18004,18003,18008,18007,18006,14119,18005],"class_list":["post-46083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-clause-in-sql","tag-sql-clauses","tag-sql-from-clause","tag-sql-select-clause","tag-sql-with-clause","tag-syntax-rules","tag-types-of-sql-clauses"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Clause in SQL - Types with Syntax and Example - DataFlair<\/title>\n<meta name=\"description\" content=\"What is Clause in SQL - Here you will learn 3 different types of SQL Clause, WITH Clause, FORM Clause, SELECT Clause, Nested Table\" \/>\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\/clause-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Clause in SQL - Types with Syntax and Example - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What is Clause in SQL - Here you will learn 3 different types of SQL Clause, WITH Clause, FORM Clause, SELECT Clause, Nested Table\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/clause-in-sql\/\" \/>\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-12-21T05:55:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-10T12:27:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Clauses.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":"Clause in SQL - Types with Syntax and Example - DataFlair","description":"What is Clause in SQL - Here you will learn 3 different types of SQL Clause, WITH Clause, FORM Clause, SELECT Clause, Nested Table","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\/clause-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"Clause in SQL - Types with Syntax and Example - DataFlair","og_description":"What is Clause in SQL - Here you will learn 3 different types of SQL Clause, WITH Clause, FORM Clause, SELECT Clause, Nested Table","og_url":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-12-21T05:55:30+00:00","article_modified_time":"2021-03-10T12:27:59+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Clauses.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\/clause-in-sql\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Clause in SQL &#8211; Types with Syntax and Example","datePublished":"2018-12-21T05:55:30+00:00","dateModified":"2021-03-10T12:27:59+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/"},"wordCount":1027,"commentCount":3,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Clauses.jpg","keywords":["Clause in SQL","SQL Clauses","SQL FROM Clause","SQL SELECT Clause","SQL WITH Clause","Syntax Rules","Types of SQL Clauses"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/clause-in-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/","url":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/","name":"Clause in SQL - Types with Syntax and Example - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Clauses.jpg","datePublished":"2018-12-21T05:55:30+00:00","dateModified":"2021-03-10T12:27:59+00:00","description":"What is Clause in SQL - Here you will learn 3 different types of SQL Clause, WITH Clause, FORM Clause, SELECT Clause, Nested Table","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/clause-in-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Clauses.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/12\/SQL-Clauses.jpg","width":1200,"height":628,"caption":"SQL Clauses"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/clause-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SQL Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sql\/"},{"@type":"ListItem","position":3,"name":"Clause in SQL &#8211; Types with Syntax and Example"}]},{"@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\/46083","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=46083"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46083\/revisions"}],"predecessor-version":[{"id":86822,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/46083\/revisions\/86822"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/86821"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=46083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=46083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=46083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}