{"id":97887,"date":"2020-12-18T11:00:00","date_gmt":"2020-12-18T09:00:00","guid":{"rendered":"https:\/\/examples.javacodegeeks.com\/?p=97887"},"modified":"2022-02-27T13:06:09","modified_gmt":"2022-02-27T11:06:09","slug":"sql-in-sql-not-in","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/","title":{"rendered":"SQL IN &#8211; SQL NOT IN"},"content":{"rendered":"<p>This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple values mentioned in the Where clause. While <code>SQL Not In<\/code> operator excludes the rows with any of the values from the <code>Where<\/code> clause. <\/p>\n<h2 class=\"wp-block-heading\" id=\"h-1-about-sql-in-and-sql-not-in-operators\">1. About SQL In and SQL Not In Operators<\/h2>\n<p>Let us first read about these <a href=\"https:\/\/docs.oracle.com\/cd\/E12095_01\/doc.10303\/e12092\/sqopr.htm\">operators<\/a> individually. <\/p>\n<h3 class=\"wp-block-heading\" id=\"h-1-1-what-is-sql-in-operator\">1.1 What is SQL In operator ?<\/h3>\n<p>Let us say you want to include all rows with the names &#8216;Alex&#8217;, or &#8216;Ayaka&#8217;, or &#8216;Bandana&#8217;. You can do this by using multiple <code>OR<\/code> operators. <code>SQL In<\/code> operator is just like using multiple <code>OR<\/code> operators. <\/p>\n<h3 class=\"wp-block-heading\" id=\"h-1-2-what-is-sql-not-in-operator\">1.2 What is SQL Not In operator?<\/h3>\n<p>The <code>SQL Not In<\/code> operator works in an opposite fashion when compared to the <code>SQL In<\/code> operator. It excludes all the values given in the Where clause from the resultant set of rows. <\/p>\n<h2 class=\"wp-block-heading\" id=\"h-2-syntax\">2. Syntax<\/h2>\n<p>Now, we will look at the syntax for both the operators. The syntax for both the operators is quite similar. <\/p>\n<h3 class=\"wp-block-heading\" id=\"h-2-1-sql-in-operator-syntax\">2.1 SQL In operator syntax<\/h3>\n<pre class=\"brush:sql\"> SELECT columnName(s) FROM tableName WHERE columnName IN (value1, value2, ... valueN);<\/pre>\n<h3 class=\"wp-block-heading\" id=\"h-2-2-sql-not-in-operator-syntax\">2.2 SQL Not In operator syntax<\/h3>\n<pre class=\"brush:sql\">SELECT columnNames(s) FROM tableName WHERE columnName NOT IN (value1, value2... valueN);<\/pre>\n<h2 class=\"wp-block-heading\" id=\"h-3-sql-in-and-sql-not-in-example\">3. SQL In and SQL Not In Example<\/h2>\n<p>Moving ahead, let us now use both the operators in an example. <div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<ol class=\"wp-block-list\">\n<li>We will start off by creating a database named &#8211; data &#8211; and a table named &#8211; information. The table information consists of three columns &#8211; id (of integer type), name (of varchar type), and country ( of varchar type). <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/1.jpg\"><img decoding=\"async\" width=\"1024\" height=\"469\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/1-1024x469.jpg\" alt=\"SQL NOT IN - Creating database\" class=\"wp-image-98189\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/1-1024x469.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/1-300x137.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/1-768x352.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/1.jpg 1100w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Creating database  &#8211; data &#8211; and table &#8211; information<\/figcaption><\/figure>\n<\/div>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/2.jpg\"><img decoding=\"async\" width=\"1024\" height=\"241\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/2-1024x241.jpg\" alt=\"SQL NOT IN - Inserting data\" class=\"wp-image-98190\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/2-1024x241.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/2-300x71.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/2-768x181.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/2.jpg 1104w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Inserting data into the table<\/figcaption><\/figure>\n<\/div>\n<p>2. Let us first use <code>SQL In<\/code> operator as an example.<\/p>\n<p>The first example selects the two columns name, and country from the table information where the name is either &#8216;Marie&#8217;, or &#8216;Kumta&#8217;.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/3.jpg\"><img decoding=\"async\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/3-1024x95.jpg\" alt=\"\" class=\"wp-image-98192\" width=\"782\" height=\"72\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/3-1024x95.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/3-300x28.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/3-768x72.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/3-1536x143.jpg 1536w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/3.jpg 1920w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/a><figcaption>IN example 1<\/figcaption><\/figure>\n<\/div>\n<p>Now, the second example selects all the names which includes the countries for which the value of id is 1, 22 or 31. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/4.jpg\"><img decoding=\"async\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/4-1024x120.jpg\" alt=\"SQL NOT IN - in 2\" class=\"wp-image-98193\" width=\"778\" height=\"90\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/4-1024x120.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/4-300x35.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/4-768x90.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/4-1536x180.jpg 1536w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/4.jpg 1920w\" sizes=\"(max-width: 778px) 100vw, 778px\" \/><\/a><figcaption>IN example 2<\/figcaption><\/figure>\n<\/div>\n<p>3.  Now, let us use <code>SQL Not In<\/code> operator as an example. <\/p>\n<p>The first example below selects id and country from the table which does not include names with an id greater than or equal to 22. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/5.jpg\"><img decoding=\"async\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/5-1024x92.jpg\" alt=\"SQL NOT IN 1\" class=\"wp-image-98195\" width=\"758\" height=\"68\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/5-1024x92.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/5-300x27.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/5-768x69.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/5-1536x138.jpg 1536w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/5.jpg 1920w\" sizes=\"(max-width: 758px) 100vw, 758px\" \/><\/a><figcaption>NOT IN example 1<\/figcaption><\/figure>\n<\/div>\n<p>The example below selects id and country from the table which doesn&#8217;t include the names &#8220;Alex&#8221;.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/6.jpg\"><img decoding=\"async\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/6-1024x100.jpg\" alt=\"\" class=\"wp-image-98196\" width=\"755\" height=\"73\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/6-1024x100.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/6-300x29.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/6-768x75.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/6-1536x150.jpg 1536w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/6.jpg 1920w\" sizes=\"(max-width: 755px) 100vw, 755px\" \/><\/a><figcaption>NOT In example 2<\/figcaption><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\" id=\"h-4-summary\">4. Summary<\/h2>\n<p>This article discusses the usage and functionality of the <code>SQL In<\/code> and <code>SQL Not In<\/code> operators. <code>SQL In<\/code> operator focuses on including either of the values present in the where clause. While the <code>SQL Not In<\/code> operator focuses on excluding either of the values present in the <code>where<\/code> clause. <\/p>\n<h2 class=\"wp-block-heading\" id=\"h-5-download-the-source-code\">5. Download the source code<\/h2>\n<p>To implement the same example about SQL IN &#8211; SQL NOT IN on your local system, or online compiler, download the source code. <\/p>\n<div class=\"download\"><strong>Download<\/strong><br \/>\nYou can download the full source code of this example here: <a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2020\/12\/SQLInAndNotIn.zip\"><strong>SQL IN &#8211; SQL NOT IN<\/strong><\/a><\/div>\n<p><strong>Last updated on Feb. 27th, 2022<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple values mentioned in the Where clause. While SQL Not In operator excludes the rows with any of the values from the Where clause. 1. About SQL In and &hellip;<\/p>\n","protected":false},"author":234,"featured_media":1204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-97887","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL IN - SQL NOT IN - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL IN - SQL NOT IN - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple\" \/>\n<meta property=\"og:url\" content=\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/\" \/>\n<meta property=\"og:site_name\" content=\"Examples Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-18T09:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-27T11:06:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Simran Koul\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simran Koul\" \/>\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:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/\"},\"author\":{\"name\":\"Simran Koul\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c\"},\"headline\":\"SQL IN &#8211; SQL NOT IN\",\"datePublished\":\"2020-12-18T09:00:00+00:00\",\"dateModified\":\"2022-02-27T11:06:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/\"},\"wordCount\":439,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"articleSection\":[\"sql\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/\",\"name\":\"SQL IN - SQL NOT IN - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"datePublished\":\"2020-12-18T09:00:00+00:00\",\"dateModified\":\"2022-02-27T11:06:09+00:00\",\"description\":\"This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple\",\"breadcrumb\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Bipartite Graph\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/examples.javacodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java Development\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Core Java\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"sql\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"SQL IN &#8211; SQL NOT IN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Examples and Code Snippets\",\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/javacodegeeks\",\"https:\/\/x.com\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c\",\"name\":\"Simran Koul\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png\",\"caption\":\"Simran Koul\"},\"description\":\"Simran has graduated as a Bachelor of Engineering in Computer Science from Chitkara University. She has undergone a 6-months long comprehensive industrial training at the reputed Centre for Development of Advanced Computing (C-DAC), where she worked on a project including the likes of Java, JSP, Servlets while the UI-UX through the pioneering HTML, CSS and JS. Her inquisitive nature and the seed of curiosity keeps her on the toes to find material to write about. Along with her interests in Software Development, she is an ardent reader and always ready-to-write writer.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/author\/simran-koul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL IN - SQL NOT IN - Java Code Geeks","description":"This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple","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:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/","og_locale":"en_US","og_type":"article","og_title":"SQL IN - SQL NOT IN - Java Code Geeks","og_description":"This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple","og_url":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/","og_site_name":"Examples Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2020-12-18T09:00:00+00:00","article_modified_time":"2022-02-27T11:06:09+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","type":"image\/jpeg"}],"author":"Simran Koul","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Simran Koul","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#article","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/"},"author":{"name":"Simran Koul","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c"},"headline":"SQL IN &#8211; SQL NOT IN","datePublished":"2020-12-18T09:00:00+00:00","dateModified":"2022-02-27T11:06:09+00:00","mainEntityOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/"},"wordCount":439,"commentCount":0,"publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","articleSection":["sql"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/","url":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/","name":"SQL IN - SQL NOT IN - Java Code Geeks","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","datePublished":"2020-12-18T09:00:00+00:00","dateModified":"2022-02-27T11:06:09+00:00","description":"This article focuses on the functionality and usage of the SQL In and the SQL Not In operators. The first operator filters out rows from the multiple","breadcrumb":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#primaryimage","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":150,"height":150,"caption":"Bipartite Graph"},{"@type":"BreadcrumbList","@id":"https:\/\/examples.javacodegeeks.com\/sql-in-sql-not-in\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/examples.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java Development","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"},{"@type":"ListItem","position":3,"name":"Core Java","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"},{"@type":"ListItem","position":4,"name":"sql","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"},{"@type":"ListItem","position":5,"name":"SQL IN &#8211; SQL NOT IN"}]},{"@type":"WebSite","@id":"https:\/\/examples.javacodegeeks.com\/#website","url":"https:\/\/examples.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Examples and Code Snippets","publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/examples.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/examples.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/5f017b27433db0a02e2ea1cedd4ec94c","name":"Simran Koul","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/02\/Capture-1-96x96.png","caption":"Simran Koul"},"description":"Simran has graduated as a Bachelor of Engineering in Computer Science from Chitkara University. She has undergone a 6-months long comprehensive industrial training at the reputed Centre for Development of Advanced Computing (C-DAC), where she worked on a project including the likes of Java, JSP, Servlets while the UI-UX through the pioneering HTML, CSS and JS. Her inquisitive nature and the seed of curiosity keeps her on the toes to find material to write about. Along with her interests in Software Development, she is an ardent reader and always ready-to-write writer.","url":"https:\/\/examples.javacodegeeks.com\/author\/simran-koul\/"}]}},"_links":{"self":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/97887","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/users\/234"}],"replies":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=97887"}],"version-history":[{"count":0,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/97887\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=97887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=97887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=97887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}