{"id":54733,"date":"2023-07-11T19:40:33","date_gmt":"2023-07-11T19:40:33","guid":{"rendered":"https:\/\/dbtut.com\/?p=54733"},"modified":"2023-07-11T19:44:47","modified_gmt":"2023-07-11T19:44:47","slug":"postgresql-any-operator","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/","title":{"rendered":"PostgreSQL Any Operator"},"content":{"rendered":"

In today’s article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.<\/p>\n

One of the results from nested queries works.<\/p>\n

General usage is as follows.<\/p>\n

SELECT*FROM table_name WHERE column_name (<,=,>,=!,<>)ANY ( SELECT * FROM table_name);<\/pre>\n
Let’s have a table with student names and let this table be named as student_all, with its number, name, and surname, and the other table with no, vize, final grades named student_vf, and using these two tables, let’s find the students with a vize grade of 38.<\/p>\n
We will use the ANY command to do this.<\/p>\n
SELECT*FROM ogrenci_all WHERE no > ANY(SELECT no FROM ogrenci_vf WHERE vize=38)  \r\n<\/pre>\n
<\/p>\n
In the plpgsql sentence above, in our first outer query, we want all the columns in the main table to come and we use the common name of the two tables in the WHERE condition to use our subquery.<\/p>\n
Then after the ANY command is written, we open parenthesis and we specify the condition in the subquery because we say bring those with 38 visas.<\/p>\n
We used \u201d > \u201d for Any but it has more than one parameter.<\/p>\n
These are as follows;<\/p>\n
=ANY:<\/strong> Represents the result or records equal to any of the results obtained from the subquery.<\/p>\n
>ANY:<\/strong> Refers to the result obtained from the subquery or records greater than any of the results.<\/p>\n
>=ANY:<\/strong> It refers to records greater than or equal to any of the subquery’s results.<\/p>\n
<ANY:<\/strong> Refers to records less than any of the results from the subquery.<\/p>\n
<=ANY:<\/strong> Indicates records less than or equal to any of the results obtained from the subquery.<\/p>\n
!=ANY or <> ANY:<\/strong> This command is generally useless because it means different from at least one of the returned records, which means fetching all records, so we can say that it means the same as SELECT * FROM.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL. One of the results from nested queries works. General usage is as follows. SELECT*FROM table_name WHERE column_name (<,=,>,=!,<>)ANY ( SELECT * FROM table_name); Let’s have a table with student names and let this …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":54735,"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-54733","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL Any Operator - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.\" \/>\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\/11\/postgresql-any-operator\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Any Operator - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T19:40:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-11T19:44:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png\" \/>\n\t<meta property=\"og:image:width\" content=\"593\" \/>\n\t<meta property=\"og:image:height\" content=\"290\" \/>\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\/11\/postgresql-any-operator\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL Any Operator\",\"datePublished\":\"2023-07-11T19:40:33+00:00\",\"dateModified\":\"2023-07-11T19:44:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/\"},\"wordCount\":295,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/\",\"name\":\"PostgreSQL Any Operator - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png\",\"datePublished\":\"2023-07-11T19:40:33+00:00\",\"dateModified\":\"2023-07-11T19:44:47+00:00\",\"description\":\"In today's article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png\",\"width\":593,\"height\":290},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Any Operator\"}]},{\"@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 Any Operator - Database Tutorials","description":"In today's article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.","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\/11\/postgresql-any-operator\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL Any Operator - Database Tutorials","og_description":"In today's article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/","og_site_name":"Database Tutorials","article_published_time":"2023-07-11T19:40:33+00:00","article_modified_time":"2023-07-11T19:44:47+00:00","og_image":[{"width":593,"height":290,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.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\/11\/postgresql-any-operator\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL Any Operator","datePublished":"2023-07-11T19:40:33+00:00","dateModified":"2023-07-11T19:44:47+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/"},"wordCount":295,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/","url":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/","name":"PostgreSQL Any Operator - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png","datePublished":"2023-07-11T19:40:33+00:00","dateModified":"2023-07-11T19:44:47+00:00","description":"In today's article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-11-223851.png","width":593,"height":290},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/11\/postgresql-any-operator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Any Operator"}]},{"@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\/54733","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=54733"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54733\/revisions"}],"predecessor-version":[{"id":54736,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54733\/revisions\/54736"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54735"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}