{"id":54630,"date":"2023-06-09T22:17:11","date_gmt":"2023-06-09T22:17:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=54630"},"modified":"2023-06-09T22:17:56","modified_gmt":"2023-06-09T22:17:56","slug":"postgresql-subquery","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/","title":{"rendered":"PostgreSQL SUBQUERY"},"content":{"rendered":"

In today’s article, we will be cover about nested queries, namely SUBQUERY.<\/p>\n

In order to write a SUBQUERY, we need to pay attention to some conditions.<\/p>\n

Some of these are as follows.<\/p>\n

SUBQUERYs are written after the first query.<\/p>\n

SUBQUERY must be written in parentheses.<\/p>\n

Appropriate operators should be used according to the number of records from SUBQUERY.<\/p>\n

For example, let’s take the average of the vize grades in our ogrenci table and list the ones that are higher than the average.<\/p>\n

First, let’s query the ogrenci table and see the data.<\/p>\n

<\/p>\n

We have seen our data, now let’s view the people who took the Bilgisayar M\u00fchendisli\u011fi course and whose vize is above the class average.<\/p>\n

<\/p>\n

In the section below, the average of the midterm grades in the second select sentence from the left is 53.444 .<\/p>\n

To see values higher than this number, it is sufficient to use the greater than sign.<\/p>\n

select adi,soyadi,vize from ogrenci_sb where vize >(select avg(vize) from ogrenci_sb);\r\n<\/pre>\n
<\/p>\n
To make the above example, we write the columns we want.<\/p>\n
I took the vize column to see the adi, soyadi and vize grades, after that, after the WHERE clause, I took the average of the visze in the SELECT clause by opening parenthesis as I will take the average of this visa.<\/p>\n
We have done the above operations with arithmetic operators, but apart from these, there are PLPGSQL clauses listed below.<\/p>\n
ALL
\nANY
\nOF
\nEXISTS
\nNOT EXISTS<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some conditions. Some of these are as follows. SUBQUERYs are written after the first query. SUBQUERY must be written in parentheses. Appropriate operators should be used according to the number of …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":54634,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-54630","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL SUBQUERY - Database Tutorials<\/title>\n<meta name=\"description\" content=\"We will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some conditions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL SUBQUERY - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"We will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some conditions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-09T22:17:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T22:17:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png\" \/>\n\t<meta property=\"og:image:width\" content=\"565\" \/>\n\t<meta property=\"og:image:height\" content=\"351\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL SUBQUERY\",\"datePublished\":\"2023-06-09T22:17:11+00:00\",\"dateModified\":\"2023-06-09T22:17:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/\"},\"wordCount\":233,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/\",\"name\":\"PostgreSQL SUBQUERY - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png\",\"datePublished\":\"2023-06-09T22:17:11+00:00\",\"dateModified\":\"2023-06-09T22:17:56+00:00\",\"description\":\"We will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some conditions.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png\",\"width\":565,\"height\":351},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL SUBQUERY\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL SUBQUERY - Database Tutorials","description":"We will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some conditions.","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:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL SUBQUERY - Database Tutorials","og_description":"We will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some conditions.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/","og_site_name":"Database Tutorials","article_published_time":"2023-06-09T22:17:11+00:00","article_modified_time":"2023-06-09T22:17:56+00:00","og_image":[{"width":565,"height":351,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL SUBQUERY","datePublished":"2023-06-09T22:17:11+00:00","dateModified":"2023-06-09T22:17:56+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/"},"wordCount":233,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/","url":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/","name":"PostgreSQL SUBQUERY - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png","datePublished":"2023-06-09T22:17:11+00:00","dateModified":"2023-06-09T22:17:56+00:00","description":"We will be cover about nested queries, namely SUBQUERY. In order to write a SUBQUERY, we need to pay attention to some conditions.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-10-011514.png","width":565,"height":351},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/09\/postgresql-subquery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL SUBQUERY"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=54630"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54630\/revisions"}],"predecessor-version":[{"id":54635,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54630\/revisions\/54635"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54634"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}