{"id":8340,"date":"2024-12-22T06:36:30","date_gmt":"2024-12-22T06:36:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tu-hoc-sql-ngay-trong-excel-voi-hoc-excel-online\/"},"modified":"2024-12-22T06:36:30","modified_gmt":"2024-12-22T06:36:30","slug":"tu-hoc-sql-ngay-trong-excel-voi-hoc-excel-online","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tu-hoc-sql-ngay-trong-excel-voi-hoc-excel-online\/","title":{"rendered":"T\u1ef1 h\u1ecdc SQL ngay trong Excel v\u1edbi H\u1ecdc Excel Online"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n 1 ch\u01b0\u01a1ng tr\u00ecnh nho nh\u1ecf ch\u1ea1y ngay trong Excel \u0111\u01b0\u1ee3c vi\u1ebft b\u1eb1ng Code VBA \u0111\u1ec3 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 th\u1eed nh\u1eefng c\u00e2u l\u1ec7nh SQL \u0111\u01a1n gi\u1ea3n. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft SQL l\u00e0 g\u00ec, th\u00ec h\u00e3y tham kh\u1ea3o b\u00e0i sau:<\/p>\n<p>http:\/\/www.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html<\/p>\n<p>Ch\u01b0\u01a1ng tr\u00ecnh n\u00e0y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n l\u00e0m g\u00ec? H\u00e3y theo d\u00f5i video sau \u0111\u00e2y:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/0ehpTsxKBYc\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p>M\u1ed9t s\u1ed1 c\u00e2u SQL m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f9ng v\u1edbi ch\u01b0\u01a1ng tr\u00ecnh \u0111\u1ec3 t\u1ef1 m\u00ecnh l\u1ecdc d\u1eef li\u1ec7u r\u1ea5t nhanh ch\u00f3ng:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/6a9c557bb21c294e2779b7ef1806fbd2\">Gist<\/a>.<\/div>\n<p>B\u1ea1n c\u00f3 th\u1ec3 download file t\u1ea1i \u0111\u00e2y:<\/p>\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/0B7hFG05g_xuxQkM3VTVubzJubWc\/view\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/drive.google.com\/file\/d\/0B7hFG05g_xuxQkM3VTVubzJubWc\/view<\/a><\/p>\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-342.gif\" title=\"vba101_92019-nho-342\"><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-759.gif\" title=\"ex101_92019-nho-759\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1eebng qu\u00ean tham kh\u1ea3o <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">kho\u00e1 VBA101<\/a> \u0111\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 VBA c\u00f3 th\u1ec3 gi\u00fap \u00edch th\u1ebf n\u00e0o trong c\u00f4ng vi\u1ec7c<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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<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-342.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8341,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8340","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\/8340","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=8340"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8340\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8341"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}