{"id":12657,"date":"2022-10-01T11:44:50","date_gmt":"2022-10-01T06:14:50","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/"},"modified":"2022-10-01T11:44:50","modified_gmt":"2022-10-01T06:14:50","slug":"solved-simplify-sql-query-for-me-please-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/","title":{"rendered":"[Solved] Simplify SQL query for me please [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-46262704\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"46262704\" data-parentid=\"46262487\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>I am not sure if I got your question all clear, this query below will give you the latest employee record if there are multiple user records &#8211;<\/p>\n<pre><code>SELECT * FROM employmentrecords WHERE id IN(SELECT MAX(id) FROM employmentrecords \n    WHERE ((date_end &gt;='2017-08-22' \n            OR date_end IS NULL \n            OR (date_end &lt;='2017-08-22' AND date_end &gt;='2017-08-08')) \n            AND date_hired &lt;='2017-08-22') \n    GROUP BY employee_id) \n    AND company_id&lt;&gt;0\n    and rownum = 1\n    order by date_hired desc\n<\/code><\/pre>\n<p>JFYI, no need to use the table name as alias if there is only one table you are fetching the data from, it just makes it hard to read the query on go.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Simplify SQL query for me please [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] I am not sure if I got your question all clear, this query below will give you the latest employee record if there are multiple user records &#8211; SELECT * FROM employmentrecords WHERE id IN(SELECT MAX(id) FROM employmentrecords WHERE ((date_end &gt;=&#8217;2017-08-22&#8242; OR date_end IS NULL OR (date_end &lt;=&#8217;2017-08-22&#8242; AND date_end &gt;=&#8217;2017-08-08&#8242;)) AND date_hired &lt;=&#8217;2017-08-22&#8242;) &#8230; <a title=\"[Solved] Simplify SQL query for me please [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\" aria-label=\"More on [Solved] Simplify SQL query for me please [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340],"class_list":["post-12657","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Simplify SQL query for me please [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Simplify SQL query for me please [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] I am not sure if I got your question all clear, this query below will give you the latest employee record if there are multiple user records &#8211; SELECT * FROM employmentrecords WHERE id IN(SELECT MAX(id) FROM employmentrecords WHERE ((date_end &gt;=&#039;2017-08-22&#039; OR date_end IS NULL OR (date_end &lt;=&#039;2017-08-22&#039; AND date_end &gt;=&#039;2017-08-08&#039;)) AND date_hired &lt;=&#039;2017-08-22&#039;) ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-01T06:14:50+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Simplify SQL query for me please [closed]\",\"datePublished\":\"2022-10-01T06:14:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\"},\"wordCount\":79,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\",\"name\":\"[Solved] Simplify SQL query for me please [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-01T06:14:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Simplify SQL query for me please [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Simplify SQL query for me please [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Simplify SQL query for me please [closed] - JassWeb","og_description":"[ad_1] I am not sure if I got your question all clear, this query below will give you the latest employee record if there are multiple user records &#8211; SELECT * FROM employmentrecords WHERE id IN(SELECT MAX(id) FROM employmentrecords WHERE ((date_end &gt;='2017-08-22' OR date_end IS NULL OR (date_end &lt;='2017-08-22' AND date_end &gt;='2017-08-08')) AND date_hired &lt;='2017-08-22') ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/","og_site_name":"JassWeb","article_published_time":"2022-10-01T06:14:50+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Simplify SQL query for me please [closed]","datePublished":"2022-10-01T06:14:50+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/"},"wordCount":79,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/","name":"[Solved] Simplify SQL query for me please [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-01T06:14:50+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-simplify-sql-query-for-me-please-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Simplify SQL query for me please [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=12657"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12657\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=12657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=12657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=12657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}