{"id":4036,"date":"2024-12-04T08:36:27","date_gmt":"2024-12-04T08:36:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/mot-vai-dieu-thu-vi-ve-sql-trong-excel\/"},"modified":"2024-12-04T08:36:27","modified_gmt":"2024-12-04T08:36:27","slug":"mot-vai-dieu-thu-vi-ve-sql-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/mot-vai-dieu-thu-vi-ve-sql-trong-excel\/","title":{"rendered":"M\u1ed9t v\u00e0i \u0111i\u1ec1u th\u00fa v\u1ecb v\u1ec1 Sql trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Sql (<b>Structured Query Language<\/b>) ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac, l\u1ea5y d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u ngu\u1ed3n t\u1ea1o ra b\u00e1o c\u00e1o. C\u00f9ng v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> kh\u00e1m ph\u00e1 m\u1ed9t v\u00e0i \u0111i\u1ec1u th\u00fa v\u1ecb v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/mot-vai-dieu-thu-vi-ve-sql-trong-excel.html\"><strong>SQL trong Excel<\/strong> <\/a>ngay nh\u00e9 c\u00e1c b\u1ea1n.\u00a0<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6750148b08f2a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/mot-vai-dieu-thu-vi-ve-sql-trong-excel.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u\">Y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/mot-vai-dieu-thu-vi-ve-sql-trong-excel.html#Cac_tu_khoa_trong_Sql\" title=\"C\u00e1c t\u1eeb kh\u00f3a trong Sql\">C\u00e1c t\u1eeb kh\u00f3a trong Sql<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/mot-vai-dieu-thu-vi-ve-sql-trong-excel.html#Su_dung_trong_Excel\" title=\"S\u1eed d\u1ee5ng trong Excel\">S\u1eed d\u1ee5ng trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/mot-vai-dieu-thu-vi-ve-sql-trong-excel.html#Cu_phap_tong_quat\" title=\"C\u00fa ph\u00e1p t\u1ed5ng qu\u00e1t\">C\u00fa ph\u00e1p t\u1ed5ng qu\u00e1t<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/mot-vai-dieu-thu-vi-ve-sql-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c sql ngay tr\u00ean Excel ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng Add- ins HocExcel Oline c\u1ee7a HocExcel Oline \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c \u0111\u00f3 nh\u00e9, n\u1ebfu m\u00e1y t\u00ednh n\u00e0o ch\u01b0a c\u00f3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">c\u00e0i \u0111\u1eb7t t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_tu_khoa_trong_Sql\"><\/span>C\u00e1c t\u1eeb kh\u00f3a trong Sql<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p>T\u1eeb kh\u00f3a SELECT<\/p>\n<\/blockquote>\n<p>SELECT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb m\u1ed9t ho\u1eb7c nhi\u1ec1u b\u1ea3ng trong c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n<blockquote>\n<p>T\u1eeb kh\u00f3a FROM<\/p>\n<\/blockquote>\n<p>FROM d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c l\u1ea5y ra t\u1eeb nh\u1eefng b\u1ea3ng n\u00e0o, v\u00e0 c\u00e1c b\u1ea3ng \u0111\u00f3\u00a0 quan h\u1ec7\u00a0\u00a0v\u1edbi nhau nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n<blockquote>\n<p>T\u1eeb kh\u00f3a\u00a0GROUP BY<\/p>\n<\/blockquote>\n<p>GROUP BY d\u00f9ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c b\u1ea3n ghi c\u00f3 nh\u1eefng gi\u00e1 tr\u1ecb li\u00ean quan v\u1edbi nhau th\u00e0nh c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a m\u1ed9t t\u1eadp h\u1ee3p nh\u1ecf h\u01a1n c\u00e1c b\u1ea3n ghi.<\/p>\n<blockquote>\n<p>\u00a0T\u1eeb kh\u00f3a HAVING<\/p>\n<\/blockquote>\n<p>HAVING d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh nh\u1eefng b\u1ea3n ghi n\u00e0o, l\u00e0 k\u1ebft qu\u1ea3 t\u1eeb t\u1eeb kh\u00f3a GROUP BY, s\u1ebd \u0111\u01b0\u1ee3c l\u1ea5y ra.<\/p>\n<blockquote>\n<p>T\u1eeb kh\u00f3a\u00a0ORDER BY<\/p>\n<\/blockquote>\n<p>ORDER BY d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u l\u1ea5y ra s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo nh\u1eefng c\u1ed9t n\u00e0o.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-321.gif\" title=\"ex101_92019-nho-321\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-136.gif\" title=\"vba101_92019-nho-136\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-321.gif\" title=\"ex101_92019-nho-321\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_trong_Excel\"><\/span>S\u1eed d\u1ee5ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_tong_quat\"><\/span>C\u00fa ph\u00e1p t\u1ed5ng qu\u00e1t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>SELECT [COT1], [COT2], [COTN]\u00a0FROM [SHEETS$obatdau:oketthuc]<\/strong><\/p>\n<\/blockquote>\n<p>C\u00e1c b\u1ea1n xem h\u00ecnh \u1ea3nh d\u01b0\u1edbi nh\u00e9.<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30465 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sql-1.png\" alt=\"mot-vai-dieu-thu-vi-ve-sql-trong-excel-1\" width=\"1920\" height=\"990\" title=\"sql-1\"><\/p>\n<p>V\u1edbi tr\u01b0\u1eddng h\u1ee3p c\u00e1c b\u1ea1n \u0111\u1eb7t name range(Kh\u00f4ng s\u1eed d\u1ee5ng Name \u0111\u1ed9ng \u0111\u01b0\u1ee3c) th\u00ec c\u00e1c b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda l\u1ea1i c\u00fa ph\u00e1p nh\u01b0 sau<\/p>\n<blockquote>\n<p><strong>SELECT [COT1], [COT2], [COTN]\u00a0FROM\u00a0 Namerange<\/strong><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30466 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sql1.png\" alt=\"mot-vai-dieu-thu-vi-ve-sql-trong-excel-2\" width=\"1920\" height=\"993\" title=\"sql1\"><\/p>\n<p>K\u1ebft h\u1ee3p v\u1edbi t\u1eeb kh\u00f3a Where \u0111\u1ec3 l\u1ecdc ra theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3.<\/p>\n<blockquote>\n<p><strong>SELECT [COT1],[COT2],[COTN] FROM NAMERANGE WHERE [COT1] = ?<\/strong><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30467\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sql2.png\" alt=\"mot-vai-dieu-thu-vi-ve-sql-trong-excel-3\" width=\"731\" height=\"474\" title=\"sql2\"><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e2u truy v\u1ea5n nh\u01b0 th\u1ebf n\u00e0o c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam t\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\"><strong>VBA Excel<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qua b\u00e0i vi\u1ebft v\u1eeba r\u1ed3i<strong> Hoc Excel Online<\/strong> hi v\u1ecdng c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch <strong>\u0111\u01b0a ng\u00f4n ng\u1eef SQL v\u00e0o trong Excel<\/strong> \u0111\u1ec3 t\u1ea1o ra b\u00e1o c\u00e1o nhanh g\u1ecdn v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-cai-bang-ham-heosql.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 c\u00e1i b\u1eb1ng h\u00e0m Heosql<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-tren-excel.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 nh\u1eadt k\u00fd chung tr\u00ean Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac-phan-2.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/file-quan-ly-kho-su-dung-add-ins-hocexcelonline.html\">File Qu\u1ea3n l\u00fd kho s\u1eed d\u1ee5ng Add \u2013 Ins HocExcelOnline<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-321.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=4036"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4036\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4037"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}