{"id":54693,"date":"2023-07-01T09:04:57","date_gmt":"2023-07-01T09:04:57","guid":{"rendered":"https:\/\/dbtut.com\/?p=54693"},"modified":"2023-07-01T09:07:13","modified_gmt":"2023-07-01T09:07:13","slug":"not-exists-clause-in-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/","title":{"rendered":"NOT EXISTS Clause In PostgreSQL"},"content":{"rendered":"

In today’s article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols.<\/p>\n

We will operate with ogrenci_all and ogrenci_vf tables, let’s see these tables and start our example.<\/p>\n

ogrenci_all table with student names:<\/p>\n

<\/p>\n

ogrenci_vf\u00a0table where student visa and final grades are entered:<\/p>\n

<\/p>\n

Let’s list both of our tables as above and now list the students whose vize and final grades have not been entered.<\/p>\n

SELECT*FROM ogrenci_all WHERE NOT EXISTS (SELECT*FROM ogrenci_vf  WHERE ogrenci_all.no = ogrenci_vf.no);\r\n<\/pre>\n
It is different when you pay attention to the ROWS numbers in the lower left corner of the pictures of the tables above, you can notice this by manually looking at the values in the no column in the tables with low number of records, but if the number of records in your tables is thousands or millions, I recommend you to use not exists.<\/p>\n
In the example below, the student whose vize and final grade has not been entered is listed.<\/p>\n
<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols. We will operate with ogrenci_all and ogrenci_vf tables, let’s see these tables and start our example. ogrenci_all table with student names: ogrenci_vf\u00a0table where student visa and final …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":54697,"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-54693","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nNOT EXISTS Clause In PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols.\" \/>\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\/07\/01\/not-exists-clause-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"NOT EXISTS Clause In PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-01T09:04:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-01T09:07:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png\" \/>\n\t<meta property=\"og:image:width\" content=\"597\" \/>\n\t<meta property=\"og:image:height\" content=\"303\" \/>\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\/07\/01\/not-exists-clause-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"NOT EXISTS Clause In PostgreSQL\",\"datePublished\":\"2023-07-01T09:04:57+00:00\",\"dateModified\":\"2023-07-01T09:07:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/\"},\"wordCount\":172,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/\",\"name\":\"NOT EXISTS Clause In PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png\",\"datePublished\":\"2023-07-01T09:04:57+00:00\",\"dateModified\":\"2023-07-01T09:07:13+00:00\",\"description\":\"In today's article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png\",\"width\":597,\"height\":303},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"NOT EXISTS Clause In PostgreSQL\"}]},{\"@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":"NOT EXISTS Clause In PostgreSQL - Database Tutorials","description":"In today's article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols.","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\/07\/01\/not-exists-clause-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"NOT EXISTS Clause In PostgreSQL - Database Tutorials","og_description":"In today's article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2023-07-01T09:04:57+00:00","article_modified_time":"2023-07-01T09:07:13+00:00","og_image":[{"width":597,"height":303,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.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\/07\/01\/not-exists-clause-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"NOT EXISTS Clause In PostgreSQL","datePublished":"2023-07-01T09:04:57+00:00","dateModified":"2023-07-01T09:07:13+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/"},"wordCount":172,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/","name":"NOT EXISTS Clause In PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png","datePublished":"2023-07-01T09:04:57+00:00","dateModified":"2023-07-01T09:07:13+00:00","description":"In today's article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and not equal symbols.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-01-120232.png","width":597,"height":303},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/01\/not-exists-clause-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"NOT EXISTS Clause In PostgreSQL"}]},{"@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\/54693","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=54693"}],"version-history":[{"count":2,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54693\/revisions"}],"predecessor-version":[{"id":54699,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54693\/revisions\/54699"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54697"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}