{"id":3408,"date":"2016-07-26T02:52:47","date_gmt":"2016-07-26T02:52:47","guid":{"rendered":"https:\/\/kiencang.net\/?p=3408"},"modified":"2016-07-26T02:52:47","modified_gmt":"2016-07-26T02:52:47","slug":"toan-tu-between-trong-sql","status":"publish","type":"post","link":"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/","title":{"rendered":"To\u00e1n t\u1eed BETWEEN trong SQL"},"content":{"rendered":"\n<p>To\u00e1n t\u1eed <code>BETWEEN<\/code> ch\u1ecdn l\u1ef1a c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m trong m\u1ed9t kho\u1ea3ng. C\u00e1c gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c ng\u00e0y th\u00e1ng.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">C\u00fa ph\u00e1p SQL <code>BETWEEN<\/code>:<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT ten_cot (c\u00f3 th\u1ec3 ch\u1ecdn nhi\u1ec1u c\u1ed9t)\nFROM ten_bang\nWHERE ten_cot BETWEEN giatri1 AND giatri2;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_60 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6577d65519bc7\" ><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6577d65519bc7\"  type=\"checkbox\" id=\"item-6577d65519bc7\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Co_so_du_lieu_Demo\" title=\"C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo\">C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Vi_du_ve_toan_tu_BETWEEN\" title=\"V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN\">V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Vi_du_ve_toan_tu_NOT_BETWEEN\" title=\"V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed NOT BETWEEN\">V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed NOT BETWEEN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Vi_du_ve_toan_tu_BETWEEN_voi_IN\" title=\"V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN v\u1edbi IN\">V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN v\u1edbi IN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Vi_du_ve_Toan_tu_BETWEEN_voi_Text_Value_van_ban\" title=\"V\u00ed d\u1ee5 v\u1ec1 To\u00e1n t\u1eed BETWEEN v\u1edbi Text Value (v\u0103n b\u1ea3n)\">V\u00ed d\u1ee5 v\u1ec1 To\u00e1n t\u1eed BETWEEN v\u1edbi Text Value (v\u0103n b\u1ea3n)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Vi_du_ve_toan_tu_NOT_BETWEEN_voi_Text_Value\" title=\"V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed NOT BETWEEN v\u1edbi Text Value\">V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed NOT BETWEEN v\u1edbi Text Value<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Bang_mau\" title=\"B\u1ea3ng m\u1eabu\">B\u1ea3ng m\u1eabu<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#Vi_du_ve_toan_tu_BETWEEN_voi_Date_Value\" title=\"V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN v\u1edbi Date Value\">V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN v\u1edbi Date Value<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Co_so_du_lieu_Demo\"><\/span>C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong ch\u01b0\u01a1ng n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind.<\/p>\n\n\n\n<p>B\u00ean d\u01b0\u1edbi l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng &#8220;Products&#8221;:<\/p>\n\n\n\n<figure class=\"wp-block-table w3-table-all notranslate\"><table><tbody><tr><th>ProductID<\/th><th>ProductName<\/th><th>SupplierID<\/th><th>CategoryID<\/th><th>Unit<\/th><th>Price<\/th><\/tr><tr><td>1<\/td><td>Chais<\/td><td>1<\/td><td>1<\/td><td>10 boxes x 20 bags<\/td><td>18<\/td><\/tr><tr><td>2<\/td><td>Chang<\/td><td>1<\/td><td>1<\/td><td>24 &#8211; 12 oz bottles<\/td><td>19<\/td><\/tr><tr><td>3<\/td><td>Aniseed Syrup<\/td><td>1<\/td><td>2<\/td><td>12 &#8211; 550 ml bottles<\/td><td>10<\/td><\/tr><tr><td>4<\/td><td>Chef Anton&#8217;s Cajun Seasoning<\/td><td>1<\/td><td>2<\/td><td>48 &#8211; 6 oz jars<\/td><td>22<\/td><\/tr><tr><td>5<\/td><td>Chef Anton&#8217;s Gumbo Mix<\/td><td>1<\/td><td>2<\/td><td>36 boxes<\/td><td>21.35<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_toan_tu_BETWEEN\"><\/span>V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00e2u l\u1ec7nh SQL sau \u0111\u00e2y l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m v\u1edbi gi\u00e1 c\u1ea3 n\u1eb1m trong kho\u1ea3ng t\u1eeb 10 \u0111\u1ebfn 20:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Products\nWHERE Price BETWEEN 10 AND 20;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_toan_tu_NOT_BETWEEN\"><\/span>V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed NOT BETWEEN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c s\u1ea3n ph\u1ea9m n\u1eb1m b\u00ean ngo\u00e0i kho\u1ea3ng \u1edf v\u00ed d\u1ee5 tr\u01b0\u1edbc, s\u1eed d\u1ee5ng <code>NOT BETWEEN<\/code>:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Products\nWHERE Price NOT BETWEEN 10 AND 20;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_toan_tu_BETWEEN_voi_IN\"><\/span>V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN v\u1edbi IN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00e2u l\u1ec7nh SQL sau l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m v\u1edbi gi\u00e1 n\u1eb1m gi\u1eefa 10 v\u00e0 20, nh\u01b0ng c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 CategoryID l\u00e0 1,2 ho\u1eb7c 3 kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Products\nWHERE (Price BETWEEN 10 AND 20)\nAND NOT CategoryID IN (1,2,3);<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_Toan_tu_BETWEEN_voi_Text_Value_van_ban\"><\/span>V\u00ed d\u1ee5 v\u1ec1 To\u00e1n t\u1eed BETWEEN v\u1edbi Text Value (v\u0103n b\u1ea3n)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00e2u l\u1ec7nh SQL sau \u0111\u00e2y l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m v\u1edbi ProductName b\u1eaft \u0111\u1ea7u v\u1edbi b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o n\u1eb1m gi\u1eefa &#8216;C&#8217; v\u00e0 &#8216;M&#8217;:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Products\nWHERE ProductName BETWEEN 'C' AND 'M';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_toan_tu_NOT_BETWEEN_voi_Text_Value\"><\/span>V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed NOT BETWEEN v\u1edbi Text Value<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00e2u l\u1ec7nh SQL sau \u0111\u00e2y l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c s\u1ea3n ph\u1ea9m v\u1edbi ProductName b\u1eaft \u0111\u1ea7u v\u1edbi b\u1ea5t k\u1ef3 k\u00fd t\u1ef1 n\u00e0o KH\u00d4NG N\u1eb0M GI\u1eeeA &#8216;C&#8217; v\u00e0 &#8216;M&#8217;:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Products\nWHERE ProductName NOT BETWEEN 'C' AND 'M';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bang_mau\"><\/span>B\u1ea3ng m\u1eabu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng &#8220;Orders&#8221;:<\/p>\n\n\n\n<figure class=\"wp-block-table w3-table-all notranslate\"><table><tbody><tr><th>OrderID<\/th><th>CustomerID<\/th><th>EmployeeID<\/th><th>OrderDate<\/th><th>ShipperID<\/th><\/tr><tr><td>10248<\/td><td>90<\/td><td>5<\/td><td>7\/4\/1996<\/td><td>3<\/td><\/tr><tr><td>10249<\/td><td>81<\/td><td>6<\/td><td>7\/5\/1996<\/td><td>1<\/td><\/tr><tr><td>10250<\/td><td>34<\/td><td>4<\/td><td>7\/8\/1996<\/td><td>2<\/td><\/tr><tr><td>10251<\/td><td>84<\/td><td>3<\/td><td>7\/9\/1996<\/td><td>1<\/td><\/tr><tr><td>10252<\/td><td>76<\/td><td>4<\/td><td>7\/10\/1996<\/td><td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_toan_tu_BETWEEN_voi_Date_Value\"><\/span>V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed BETWEEN v\u1edbi Date Value<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00e2u l\u1ec7nh SQL sau \u0111\u00e2y l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u0111\u01a1n h\u00e0ng c\u00f3 OderDate n\u1eb1m trong kho\u1ea3ng t\u1eed &#8217;04-July-1996&#8242; v\u00e0 &#8217;09-July-1996&#8242;:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM Orders\nWHERE OrderDate BETWEEN #07\/04\/1996# AND #07\/09\/1996#;<\/code><\/pre>\n\n\n\n<p>L\u01b0u \u00fd &nbsp;l\u00e0 to\u00e1n t\u1eed <code>BETWEEN<\/code> c\u00f3 th\u1ec3 t\u1ea1o ra nhi\u1ec1u k\u1ebft qu\u1ea3 kh\u00e1c nhau trong c\u00e1c c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c nhau!<\/p>\n\n\n\n<p>Trong m\u1ed9t s\u1ed1 c\u01a1 s\u1edf d\u1eef li\u1ec7u, <code>BETWEEN<\/code> l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng n\u1eb1m gi\u1eefa v\u00e0 kh\u00f4ng bao g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb ki\u1ec3m tra.<\/p>\n\n\n\n<p>Trong m\u1ed9t s\u1ed1 c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c, <code>BETWEEN<\/code> l\u1ef1a ch\u1ecdn c\u00e1c tr\u01b0\u1eddng n\u1eb1m gi\u1eefa v\u00e0 bao g\u1ed3m lu\u00f4n c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb ki\u1ec3m tra.<\/p>\n\n\n\n<p>V\u00e0 trong m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c, <code>BETWEEN<\/code> l\u1ef1a ch\u1ecdn c\u00e1c tr\u01b0\u1eddng n\u1eb1m gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb ki\u1ec3m tra, tuy nhi\u00ean l\u1ea1i bao g\u1ed3m gi\u00e1 tr\u1ecb ki\u1ec3m tra \u0111\u1ea7u ti\u00ean nh\u01b0ng kh\u00f4ng bao g\u1ed3m gi\u00e1 tr\u1ecb ki\u1ec3m tra th\u1ee9 hai.<\/p>\n\n\n\n<p><strong>V\u00ec v\u1eady h\u00e3y ki\u1ebfm tra c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n x\u1eed l\u00fd nh\u01b0 th\u1ebf n\u00e0o v\u1edbi to\u00e1n t\u1eed BETWEEN.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To\u00e1n t\u1eed BETWEEN ch\u1ecdn l\u1ef1a c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m trong m\u1ed9t kho\u1ea3ng. C\u00e1c gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c ng\u00e0y th\u00e1ng. C\u00fa ph\u00e1p SQL BETWEEN: C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo Trong ch\u01b0\u01a1ng n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind. B\u00ean d\u01b0\u1edbi l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[239],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>To\u00e1n t\u1eed BETWEEN trong SQL &#8226; Ki\u1ebfn c\u00e0ng<\/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:\/\/kiencang.net\/toan-tu-between-trong-sql\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"To\u00e1n t\u1eed BETWEEN trong SQL &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"To\u00e1n t\u1eed BETWEEN ch\u1ecdn l\u1ef1a c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m trong m\u1ed9t kho\u1ea3ng. C\u00e1c gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c ng\u00e0y th\u00e1ng. C\u00fa ph\u00e1p SQL BETWEEN: C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo Trong ch\u01b0\u01a1ng n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind. B\u00ean d\u01b0\u1edbi l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-26T02:52:47+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"To\u00e1n t\u1eed BETWEEN trong SQL &#8226; Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/toan-tu-between-trong-sql\/","og_locale":"vi_VN","og_type":"article","og_title":"To\u00e1n t\u1eed BETWEEN trong SQL &#8226; Ki\u1ebfn c\u00e0ng","og_description":"To\u00e1n t\u1eed BETWEEN ch\u1ecdn l\u1ef1a c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m trong m\u1ed9t kho\u1ea3ng. C\u00e1c gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 l\u00e0 s\u1ed1, v\u0103n b\u1ea3n ho\u1eb7c ng\u00e0y th\u00e1ng. C\u00fa ph\u00e1p SQL BETWEEN: C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo Trong ch\u01b0\u01a1ng n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind. B\u00ean d\u01b0\u1edbi l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng &hellip;","og_url":"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-26T02:52:47+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"3 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/","url":"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/","name":"To\u00e1n t\u1eed BETWEEN trong SQL &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-26T02:52:47+00:00","dateModified":"2016-07-26T02:52:47+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/toan-tu-between-trong-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/toan-tu-between-trong-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"To\u00e1n t\u1eed BETWEEN trong SQL"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3408"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=3408"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3408\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}