{"id":1029,"date":"2016-09-17T11:14:50","date_gmt":"2016-09-17T11:14:50","guid":{"rendered":"http:\/\/www.csestack.org\/?p=1029"},"modified":"2019-07-26T12:03:02","modified_gmt":"2019-07-26T06:33:02","slug":"select-sql-command","status":"publish","type":"post","link":"https:\/\/www.csestack.org\/select-sql-command\/","title":{"rendered":"Select SQL Command | Aggregate Functions with Example"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-5586\" src=\"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png\" alt=\"Learn MySQL commands\" width=\"728\" height=\"420\" srcset=\"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png 728w, https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands-300x173.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/p>\n<p>The most important part of Database Management is the retrieval of the correct data in the most efficient way. The query for data retrieval is the select SQL command. This makes the select query one of the most important queries in SQL.<\/p>\n<p><strong>Pre-requisite:<\/strong> This tutorial is about MySQL database. If you have not used MySQL database earlier, check <a href=\"https:\/\/www.csestack.org\/mysql-commands\/\">complete MySQL tutorial<\/a>.<\/p>\n<div class=\"toc\">\n<p><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#syntax\">Select Query Syntax<\/a><\/li>\n<li><a href=\"#example\">Select Query Example<\/a><\/li>\n<li><a href=\"#aggregate-functions\">Aggregate Functions in Select SQL Command<\/a><\/li>\n<li><a href=\"#filters\">Filters in SQL Query<\/a>\n<ul>\n<li><a href=\"#where-condition\">\u2018where\u2019 condition<\/a><\/li>\n<li><a href=\"#group-by\">Group by<\/a><\/li>\n<li><a href=\"#having-clause\">Having Clause<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#order-by-clause\">ORDER BY Clause in Select SQL Command<\/a><\/li>\n<\/ul>\n<\/div>\n<h3 id=\"syntax\" style=\"text-align: center;\">Select Query Syntax<\/h3>\n<p>The basic syntax of the Select statement is \u2013<\/p>\n<pre>Select &lt;<em>attribute_list&gt; and &lt;function_list&gt;<\/em>\r\nfrom &lt;<em>table_list&gt;<\/em>\r\ngroup by &lt;<em>grouping_attribute&gt;<\/em>\r\nhaving &lt;<em>group_condition&gt;<\/em>\r\norder by &lt;<em>attribute_list&gt;;<\/em>\r\n<\/pre>\n<p>We will discuss all of the keywords ones by one.<\/p>\n<h3 id=\"example\" style=\"text-align: center;\">Select Query Example<\/h3>\n<p>Take an instance, Employee is the\u00a0table in the database which contains column attributes as an employee unique id (E_id), employee name (E_Name), employee monthly salary (salary), employee department D_number, etc&#8230;<\/p>\n<p><strong>The simplest possible Select query is:<\/strong><\/p>\n<pre>Select E_name from Employee;<\/pre>\n<p>Here, the E_name column of the Employee table will be displayed.<\/p>\n<p><strong>Write a SQL query to select multiple columns.<\/strong><\/p>\n<pre>Select E_id, E_name from Employee;<\/pre>\n<p><strong>Write a SQL query to select all columns.<\/strong><\/p>\n<pre>Select * from Employee;<\/pre>\n<p>Note: Here asterisk (*) denotes all.<\/p>\n<h3 id=\"aggregate-functions\" style=\"text-align: center;\">Aggregate Functions in Select SQL Command<\/h3>\n<p>There are many aggregate functions available in SQL. They include \u2013<\/p>\n<ul>\n<li>Max() \u2013 Returns the maximum value.<\/li>\n<li>Min() \u2013 Returns the minimum value.<\/li>\n<li>Avg() \u2013 Returns the average value.<\/li>\n<li>Count() &#8211; Returns the number of rows.<\/li>\n<li>Sum() \u2013 Returns the sum of all values.<\/li>\n<\/ul>\n<p>Within the parenthesis, we write the name of the column on which we want the aggregate function to operate.<\/p>\n<p>For e.g.:<\/p>\n<pre>Select max(salary) from Employee;<\/pre>\n<p>We can also include all (*) as a parameter.<\/p>\n<p>For e.g.:<\/p>\n<pre>Select count(*) from Employee;<\/pre>\n<h3 id=\"filters\" style=\"text-align: center;\">Filters in SQL Query:<\/h3>\n<h4 id=\"where-condition\">\u2018where\u2019 condition:<\/h4>\n<p>To give a particular condition for selection of rows, we use \u2018where\u2019 in our select SQL command.<\/p>\n<p>For e.g.:<\/p>\n<pre>Select E_name from Employee where salary&gt;10000;<\/pre>\n<p>This statement selects the names of employees whose salary is more than 10,000.<\/p>\n<h4 id=\"group-by\">Group by:<\/h4>\n<p>This is used to group together tuples (rows) of a particular type.<\/p>\n<p>You may want to view the tuples of people belonging to the same department together in your resultant table. For this, we can write \u2013<\/p>\n<pre>Select E_name, D_number from Employees group by D_number;<\/pre>\n<p>To view the number of Employees in a department and the average salary of the department, we use the following query\u2013<\/p>\n<pre>Select D_number, count(*), avg(salary) from Employee group by D_number;<\/pre>\n<h4 id=\"having-clause\">Having Clause:<\/h4>\n<p>This clause contains the group condition.<\/p>\n<p>This means that the grouping is done first and then this condition is applied to retrieve the final results.<\/p>\n<p>For e.g.: In the following query,<\/p>\n<pre>Select D_number, count(*), avg(salary) from Employee group by D_number having count(*)&gt;2;<\/pre>\n<p>First, groups are created according to the department number, the count is calculated for each department and then it is checked if the department has more than two employees.<br \/>\nIf it has more than two employees, then it is retrieved in the result set.<\/p>\n<h3 id=\"order-by-clause\" style=\"text-align: center;\">ORDER BY Clause in Select SQL Command<\/h3>\n<p>This is used to arrange the tuples in a particular order. This order can be numerical or alphabetical.<\/p>\n<p>For e.g.:<\/p>\n<pre>Select E_id, E_name from Employee order by E_id;<\/pre>\n<p>This query orders the list as per the ascending order of employee id (numerical) whereas<\/p>\n<pre>Select E_id, E_name from Employee order by E_name;<\/pre>\n<p>This query orders the list as per the ascending order of E_name (alphabetical).<\/p>\n<p>By default, everything is ordered in ascending order.<\/p>\n<p>To define if the order is ascending or descending in the case of both alphabets and numbers, we use ASC and DESC.<\/p>\n<p>For e.g.:<\/p>\n<pre>Select E_id, E_name from Employee order by E_name DESC;<\/pre>\n<p>This select SQL command retrieves the Employee name and Employee id with the Employee name arranged in reverse alphabetical order.<\/p>\n<p>That is all about the most important select SQL commands. This creates a strong foundation to learn further concepts. Other queries shall be discussed in the forthcoming posts.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select SQL commands syntax and example explained with different filters like &#8216;where&#8217;, &#8216;group by&#8217;, &#8216;having clause&#8217; and &#8216;order by&#8217; clause in MySQL database.<\/p>\n","protected":false},"author":3,"featured_media":5586,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,18,116],"tags":[108,118,314,117],"class_list":["post-1029","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-code","category-cse-subject","category-dbms","category-sql","tag-db","tag-dbms","tag-mysql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Select SQL Command | Aggregate Functions with Example<\/title>\n<meta name=\"description\" content=\"Select SQL commands syntax and example explained with different filters like &#039;where&#039;, &#039;group by&#039;, &#039;having clause&#039; and &#039;order by&#039; clause in MySQL database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.csestack.org\/select-sql-command\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Select SQL Command | Aggregate Functions with Example\" \/>\n<meta property=\"og:description\" content=\"Select SQL commands syntax and example explained with different filters like &#039;where&#039;, &#039;group by&#039;, &#039;having clause&#039; and &#039;order by&#039; clause in MySQL database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.csestack.org\/select-sql-command\/\" \/>\n<meta property=\"og:site_name\" content=\"CSEstack\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/aniruddha.ca\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/heena.rajpal.92\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-17T11:14:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-26T06:33:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png\" \/>\n\t<meta property=\"og:image:width\" content=\"728\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Heena Rajpal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@CSEStack\" \/>\n<meta name=\"twitter:site\" content=\"@ani_chaudhari\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Heena Rajpal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/\"},\"author\":{\"name\":\"Heena Rajpal\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/#\\\/schema\\\/person\\\/bcfd2bc3f1df686d0c860ff160dbd4d5\"},\"headline\":\"Select SQL Command | Aggregate Functions with Example\",\"datePublished\":\"2016-09-17T11:14:50+00:00\",\"dateModified\":\"2019-07-26T06:33:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/\"},\"wordCount\":588,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/#\\\/schema\\\/person\\\/634ef1a9c4f38b0d340c6d45fa771218\"},\"image\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/Learn-MySQL-commands.png\",\"keywords\":[\"db\",\"DBMS\",\"MySQL\",\"SQL\"],\"articleSection\":[\"Code\",\"CSE Subject\",\"DBMS\",\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/\",\"url\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/\",\"name\":\"Select SQL Command | Aggregate Functions with Example\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/Learn-MySQL-commands.png\",\"datePublished\":\"2016-09-17T11:14:50+00:00\",\"dateModified\":\"2019-07-26T06:33:02+00:00\",\"description\":\"Select SQL commands syntax and example explained with different filters like 'where', 'group by', 'having clause' and 'order by' clause in MySQL database.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/Learn-MySQL-commands.png\",\"contentUrl\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/Learn-MySQL-commands.png\",\"width\":728,\"height\":420,\"caption\":\"Learn MySQL commands\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/select-sql-command\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.csestack.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Select SQL Command | Aggregate Functions with Example\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/#website\",\"url\":\"https:\\\/\\\/www.csestack.org\\\/\",\"name\":\"CSEstack\",\"description\":\"Computer Science &amp; Programming Portal\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/#\\\/schema\\\/person\\\/634ef1a9c4f38b0d340c6d45fa771218\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.csestack.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.csestack.org\\\/#\\\/schema\\\/person\\\/634ef1a9c4f38b0d340c6d45fa771218\",\"name\":\"Aniruddha Chaudhari\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/Aniruddha-Chaudhari.jpg\",\"url\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/Aniruddha-Chaudhari.jpg\",\"contentUrl\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/Aniruddha-Chaudhari.jpg\",\"width\":634,\"height\":634,\"caption\":\"Aniruddha Chaudhari\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.csestack.org\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/Aniruddha-Chaudhari.jpg\"},\"description\":\"I am a Python enthusiast who loves Linux and Vim. I hold a Master of Computer Science degree from NIT Trichy and have 10 years of experience in the IT industry, focusing on the Software Development Lifecycle from Requirements Gathering, Design, Development to Deployment. I have worked at IBM, Ericsson, and NetApp, and I share my knowledge on CSEstack.org.\",\"sameAs\":[\"https:\\\/\\\/www.csestack.org\",\"https:\\\/\\\/www.facebook.com\\\/aniruddha.ca\",\"pythonwithani\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/aniruddha28\\\/\",\"https:\\\/\\\/x.com\\\/ani_chaudhari\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCw0a__B0eJsvCujkSIfLTAA\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.csestack.org\\\/#\\\/schema\\\/person\\\/bcfd2bc3f1df686d0c860ff160dbd4d5\",\"name\":\"Heena Rajpal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1c4d4623a1f3e320028dfaaaacac33f289821b36158ed3d314c69802fde4855e?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1c4d4623a1f3e320028dfaaaacac33f289821b36158ed3d314c69802fde4855e?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1c4d4623a1f3e320028dfaaaacac33f289821b36158ed3d314c69802fde4855e?s=96&d=monsterid&r=g\",\"caption\":\"Heena Rajpal\"},\"description\":\"Heena Rajpal is pursuing Computer Science Engineering from Indore. She has a knack for writing and an inquisitive outlook towards Computer Science fields like Database Management Systems, Object Oriented Programming and languages like C, C++, JAVA, Python, HTML etc.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/heena.rajpal.92\"],\"url\":\"https:\\\/\\\/www.csestack.org\\\/author\\\/heena\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Select SQL Command | Aggregate Functions with Example","description":"Select SQL commands syntax and example explained with different filters like 'where', 'group by', 'having clause' and 'order by' clause in MySQL database.","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:\/\/www.csestack.org\/select-sql-command\/","og_locale":"en_US","og_type":"article","og_title":"Select SQL Command | Aggregate Functions with Example","og_description":"Select SQL commands syntax and example explained with different filters like 'where', 'group by', 'having clause' and 'order by' clause in MySQL database.","og_url":"https:\/\/www.csestack.org\/select-sql-command\/","og_site_name":"CSEstack","article_publisher":"https:\/\/www.facebook.com\/aniruddha.ca","article_author":"https:\/\/www.facebook.com\/heena.rajpal.92","article_published_time":"2016-09-17T11:14:50+00:00","article_modified_time":"2019-07-26T06:33:02+00:00","og_image":[{"width":728,"height":420,"url":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png","type":"image\/png"}],"author":"Heena Rajpal","twitter_card":"summary_large_image","twitter_creator":"@CSEStack","twitter_site":"@ani_chaudhari","twitter_misc":{"Written by":"Heena Rajpal","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.csestack.org\/select-sql-command\/#article","isPartOf":{"@id":"https:\/\/www.csestack.org\/select-sql-command\/"},"author":{"name":"Heena Rajpal","@id":"https:\/\/www.csestack.org\/#\/schema\/person\/bcfd2bc3f1df686d0c860ff160dbd4d5"},"headline":"Select SQL Command | Aggregate Functions with Example","datePublished":"2016-09-17T11:14:50+00:00","dateModified":"2019-07-26T06:33:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.csestack.org\/select-sql-command\/"},"wordCount":588,"commentCount":0,"publisher":{"@id":"https:\/\/www.csestack.org\/#\/schema\/person\/634ef1a9c4f38b0d340c6d45fa771218"},"image":{"@id":"https:\/\/www.csestack.org\/select-sql-command\/#primaryimage"},"thumbnailUrl":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png","keywords":["db","DBMS","MySQL","SQL"],"articleSection":["Code","CSE Subject","DBMS","SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.csestack.org\/select-sql-command\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.csestack.org\/select-sql-command\/","url":"https:\/\/www.csestack.org\/select-sql-command\/","name":"Select SQL Command | Aggregate Functions with Example","isPartOf":{"@id":"https:\/\/www.csestack.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.csestack.org\/select-sql-command\/#primaryimage"},"image":{"@id":"https:\/\/www.csestack.org\/select-sql-command\/#primaryimage"},"thumbnailUrl":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png","datePublished":"2016-09-17T11:14:50+00:00","dateModified":"2019-07-26T06:33:02+00:00","description":"Select SQL commands syntax and example explained with different filters like 'where', 'group by', 'having clause' and 'order by' clause in MySQL database.","breadcrumb":{"@id":"https:\/\/www.csestack.org\/select-sql-command\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.csestack.org\/select-sql-command\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.csestack.org\/select-sql-command\/#primaryimage","url":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png","contentUrl":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/07\/Learn-MySQL-commands.png","width":728,"height":420,"caption":"Learn MySQL commands"},{"@type":"BreadcrumbList","@id":"https:\/\/www.csestack.org\/select-sql-command\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.csestack.org\/"},{"@type":"ListItem","position":2,"name":"Select SQL Command | Aggregate Functions with Example"}]},{"@type":"WebSite","@id":"https:\/\/www.csestack.org\/#website","url":"https:\/\/www.csestack.org\/","name":"CSEstack","description":"Computer Science &amp; Programming Portal","publisher":{"@id":"https:\/\/www.csestack.org\/#\/schema\/person\/634ef1a9c4f38b0d340c6d45fa771218"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.csestack.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.csestack.org\/#\/schema\/person\/634ef1a9c4f38b0d340c6d45fa771218","name":"Aniruddha Chaudhari","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/03\/Aniruddha-Chaudhari.jpg","url":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/03\/Aniruddha-Chaudhari.jpg","contentUrl":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/03\/Aniruddha-Chaudhari.jpg","width":634,"height":634,"caption":"Aniruddha Chaudhari"},"logo":{"@id":"https:\/\/www.csestack.org\/wp-content\/uploads\/2019\/03\/Aniruddha-Chaudhari.jpg"},"description":"I am a Python enthusiast who loves Linux and Vim. I hold a Master of Computer Science degree from NIT Trichy and have 10 years of experience in the IT industry, focusing on the Software Development Lifecycle from Requirements Gathering, Design, Development to Deployment. I have worked at IBM, Ericsson, and NetApp, and I share my knowledge on CSEstack.org.","sameAs":["https:\/\/www.csestack.org","https:\/\/www.facebook.com\/aniruddha.ca","pythonwithani","https:\/\/www.linkedin.com\/in\/aniruddha28\/","https:\/\/x.com\/ani_chaudhari","https:\/\/www.youtube.com\/channel\/UCw0a__B0eJsvCujkSIfLTAA"]},{"@type":"Person","@id":"https:\/\/www.csestack.org\/#\/schema\/person\/bcfd2bc3f1df686d0c860ff160dbd4d5","name":"Heena Rajpal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1c4d4623a1f3e320028dfaaaacac33f289821b36158ed3d314c69802fde4855e?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1c4d4623a1f3e320028dfaaaacac33f289821b36158ed3d314c69802fde4855e?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1c4d4623a1f3e320028dfaaaacac33f289821b36158ed3d314c69802fde4855e?s=96&d=monsterid&r=g","caption":"Heena Rajpal"},"description":"Heena Rajpal is pursuing Computer Science Engineering from Indore. She has a knack for writing and an inquisitive outlook towards Computer Science fields like Database Management Systems, Object Oriented Programming and languages like C, C++, JAVA, Python, HTML etc.","sameAs":["https:\/\/www.facebook.com\/heena.rajpal.92"],"url":"https:\/\/www.csestack.org\/author\/heena\/"}]}},"_links":{"self":[{"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/posts\/1029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/comments?post=1029"}],"version-history":[{"count":6,"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/posts\/1029\/revisions"}],"predecessor-version":[{"id":5591,"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/posts\/1029\/revisions\/5591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/media\/5586"}],"wp:attachment":[{"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/media?parent=1029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/categories?post=1029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.csestack.org\/wp-json\/wp\/v2\/tags?post=1029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}