{"id":8911,"date":"2024-12-29T06:08:29","date_gmt":"2024-12-29T06:08:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql\/"},"modified":"2024-12-29T06:08:29","modified_gmt":"2024-12-29T06:08:29","slug":"huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1ecdc d\u1eef li\u1ec7u trong EXCEL theo Database b\u1eb1ng SQL"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<blockquote>\n<p>\u0110\u00e2y l\u00e0 b\u00e0i s\u1ed1 #26 trong lo\u1ea1t videos <a href=\"https:\/\/www.youtube.com\/playlist?list=PLALCv46JuKELXd5Ie81UqaFqAfsoXQSQt\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>H\u01b0\u1edbng d\u1eabn VBA trong Excel v\u00e0 \u1ee9ng d\u1ee5ng c\u1ee7a VBA trong c\u00f4ng vi\u1ec7c<\/strong><\/a><\/p>\n<\/blockquote>\n<hr>\n<p>\u0110\u00e3 bao gi\u1edd c\u00e1c b\u1ea1n ph\u1ea3i x\u1eed l\u00fd m\u1ed9t l\u01b0\u1ee3ng d\u1eef li\u1ec7u r\u1ea5t l\u1edbn \u1edf trong Excel t\u1eeb v\u00e0i ch\u1ee5c ng\u00e0n cho \u0111\u1ebfn h\u00e0ng tr\u0103m ng\u00e0n d\u00f2ng? C\u00e1c c\u00f4ng c\u1ee5 <code class=\"highlighter-rouge\">filter<\/code> hay<code class=\"highlighter-rouge\">b\u1ea3ng pivot<\/code> c\u00f3 th\u1ec3 m\u1ed9t ph\u1ea7n n\u00e0o x\u1eed l\u00fd \u0111\u01b0\u1ee3c nh\u1eefng c\u00f4ng vi\u1ec7c tr\u00edch l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n, s\u1eafp x\u1ebfp d\u1eef li\u1ec7u n\u1eb7ng nh\u1ecdc n\u00e0y trong Excel cho b\u1ea1n nh\u01b0ng v\u1edbi t\u1ed1c \u0111\u1ed9 kh\u00e1 ch\u1eadm, v\u00e0 \u0111\u00f4i khi ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 g\u1eb7p tr\u01b0\u1eddng h\u1ee3p treo m\u00e1y t\u00ednh ho\u1eb7c Excel ng\u1eebng ho\u1ea1t \u0111\u1ed9ng b\u1edfi v\u00ec l\u01b0\u1ee3ng d\u1eef li\u1ec7u n\u00e0y qu\u00e1 l\u1edbn th\u1eadm ch\u00ed Excel c\u00f3 th\u1ec3 tho\u00e1t lu\u00f4n v\u00e0 kh\u00f4ng th\u1ec3 kh\u00f4i ph\u1ee5c \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u? Khi t\u1ea5t c\u1ea3 c\u00e1c k\u0129 thu\u1eadt x\u1eed l\u00fd d\u1eef li\u1ec7u b\u00ecnh th\u01b0\u1eddng trong excel \u0111\u00e3 \u0111\u01b0\u1ee3c th\u1eed qua, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 ngh\u0129 \u0111\u1ebfn <code class=\"highlighter-rouge\">SQL<\/code>. V\u1eady <code class=\"highlighter-rouge\">SQL<\/code> l\u00e0 g\u00ec v\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng <code class=\"highlighter-rouge\">SQL<\/code> trong <code class=\"highlighter-rouge\">Excel<\/code> nh\u01b0 th\u1ebf n\u00e0o? B\u00e0i vi\u1ebft v\u00e0 video n\u00e0y s\u1ebd gi\u00fap cho c\u00e1c b\u1ea1n c\u00f3 th\u00eam m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu d\u1ee5ng n\u1eefa \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel.<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/-gsMj4seais?list=PLALCv46JuKELXd5Ie81UqaFqAfsoXQSQt&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><a href=\"https:\/\/www.dropbox.com\/s\/o3sftlsb6p2xcac\/Excel%2067%20SQL%20trong%20EXCEL_ductnguy.xlsm?dl=1\" target=\"_blank\" rel=\"noopener noreferrer\">Download excel file k\u00e8m theo video<\/a><\/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-6770e75c26f0d\" 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\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql.html#SQL_la_cai_gi\" title=\"SQL l\u00e0 c\u00e1i g\u00ec?\">SQL l\u00e0 c\u00e1i g\u00ec?<\/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\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql.html#Vi_du_ve_su_dung_SQL_trong_Excel\" title=\"V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng SQL trong Excel\">V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng SQL trong Excel<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\">\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\">\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql.html#Bang_du_lieu_trong_Video\" title=\"B\u1ea3ng d\u1eef li\u1ec7u trong Video\">B\u1ea3ng d\u1eef li\u1ec7u trong Video<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql.html#Su_dung_SQL_de_loc_hay_truy_cap_du_lieu_trong_bang_tinh\" title=\"S\u1eed d\u1ee5ng SQL \u0111\u1ec3 l\u1ecdc hay truy c\u1eadp d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh\">S\u1eed d\u1ee5ng SQL \u0111\u1ec3 l\u1ecdc hay truy c\u1eadp d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh<\/a>\n<ul class=\"ez-toc-list-level-6\">\n<li class=\"ez-toc-heading-level-6\">\n<ul class=\"ez-toc-list-level-6\">\n<li class=\"ez-toc-heading-level-6\">\n<ul class=\"ez-toc-list-level-6\">\n<li class=\"ez-toc-heading-level-6\">\n<ul class=\"ez-toc-list-level-6\">\n<li class=\"ez-toc-heading-level-6\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql.html#Truy_cap_du_lieu_tu_bang_tinh_Excel_bang_SQL\" title=\"Truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL\">Truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-6\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql.html#Loc_du_lieu_bang_tinh_Excel_bang_SQL\" title=\"L\u1ecdc d\u1eef li\u1ec7u b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL\">L\u1ecdc d\u1eef li\u1ec7u b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-loc-du-lieu-trong-excel-theo-database-bang-sql.html#Download_tai_lieu_kem_theo_video_tai_day\" title=\"Download t\u00e0i li\u1ec7u k\u00e8m theo video t\u1ea1i \u0111\u00e2y\">Download t\u00e0i li\u1ec7u k\u00e8m theo video t\u1ea1i \u0111\u00e2y<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 id=\"sql-l-ci-g\"><span class=\"ez-toc-section\" id=\"SQL_la_cai_gi\"><\/span>SQL l\u00e0 c\u00e1i g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>SQL<\/strong> l\u00e0 t\u1eeb vi\u1ebft t\u1eaft ti\u1ebfng Anh c\u1ee7a <strong>Structured Query Language<\/strong>, l\u00e0 m\u1ed9t ng\u00f4n ng\u1eef \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n chuy\u00ean \u0111\u1ec3 truy v\u1ea5n d\u1eef li\u1ec7u t\u1eeb m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u (<a href=\"https:\/\/vi.wikipedia.org\/wiki\/SQL\" target=\"_blank\" rel=\"noopener noreferrer\">Wikipedia<\/a>).<\/p>\n<p>N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n h\u01a1n th\u00ec <code class=\"highlighter-rouge\">SQL<\/code> s\u1ebd gi\u00fap ch\u00fang ta l\u1ea5y d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh n\u00e0y sang b\u1ea3ng t\u00ednh kh\u00e1c ho\u1eb7c <code class=\"highlighter-rouge\">SQL<\/code> s\u1ebd gi\u00fap ch\u00fang ta l\u1ecdc d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau theo c\u00e1ch m\u00e0 c\u00e1c c\u00f4ng c\u1ee5 truy\u1ec1n th\u1ed1ng nh\u01b0 <a href=\"http:\/\/www.hocexcel.online\/2014\/06\/03\/b41-su-dung-advanced-filter-de-trich-loc-du-lieu-bang-tinh-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Advanced Filter<\/strong><\/a> hay <a href=\"http:\/\/www.hocexcel.online\/2015\/04\/25\/series-pivot-cach-dung-bang-pivot-trong-excel.html\"><strong>B\u1ea3ng Pivot<\/strong><\/a> c\u00f3 th\u1ec3 g\u1eb7p kh\u00f3 kh\u0103n khi x\u1eed l\u00fd r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u.<\/p>\n<h2 id=\"v-d-v-s-dng-sql-trong-excel\"><span class=\"ez-toc-section\" id=\"Vi_du_ve_su_dung_SQL_trong_Excel\"><\/span>V\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng SQL trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h5 id=\"bng-d-liu-trong-video\"><span class=\"ez-toc-section\" id=\"Bang_du_lieu_trong_Video\"><\/span>B\u1ea3ng d\u1eef li\u1ec7u trong Video<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp t\u1eeb <strong>Excel Online<\/strong>, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng m\u1ed9t tr\u00ecnh duy\u1ec7t Web hi\u1ec7n \u0111\u1ea1i (Google Chrome, Firefox, Safari) \u0111\u1ec3 c\u00f3 th\u1ec3 xem \u0111\u01b0\u1ee3c b\u1ea3ng Excel n\u00e0y tr\u1ef1c ti\u1ebfp. T\u00e0i li\u1ec7u Excel n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c download <a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>t\u1ea1i \u0111\u00e2y<\/strong><\/a><\/p>\n<p style=\"text-align: center\"><\/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-354.gif\" title=\"vba101_92019-nho-354\"><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-836.gif\" title=\"ex101_92019-nho-836\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Tr\u01b0\u1edbc khi x\u1eed l\u00fd b\u1ea5t k\u00ec d\u1eef li\u1ec7u n\u00e0o, ch\u00fang ta c\u1ea7n \u0111i t\u00ecm hi\u1ec3u c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u \u1edf \u0111\u00e2y:<\/p>\n<ul>\n<li>B\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta bao g\u1ed3m 7 c\u1ed9t t\u1eeb c\u1ed9t A cho \u0111\u1ebfn c\u1ed9t G.<\/li>\n<li>V\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u01b0u l\u00e0 <code class=\"highlighter-rouge\">A1:G20000<\/code><\/li>\n<li>M\u1ed7i c\u1ed9t ch\u1ee9a m\u1ed9t thu\u1ed9c t\u00ednh c\u1ee7a d\u1eef li\u1ec7u:\n<ol>\n<li>C\u1ed9t A: <code class=\"highlighter-rouge\">Ng\u00e0y b\u00e1n<\/code> (OrderDate)<\/li>\n<li>C\u1ed9t B: <code class=\"highlighter-rouge\">V\u00f9ng b\u00e1n<\/code> (Region)<\/li>\n<li>C\u1ed9t C: <code class=\"highlighter-rouge\">Ng\u01b0\u1eddi b\u00e1n<\/code> (Rep)<\/li>\n<li>C\u1ed9t D: <code class=\"highlighter-rouge\">M\u00f3n h\u00e0ng<\/code>(Item)<\/li>\n<li>C\u1ed9t E: <code class=\"highlighter-rouge\">S\u1ed1 l\u01b0\u1ee3ng<\/code> (Units)<\/li>\n<li>C\u1ed9t F: <code class=\"highlighter-rouge\">\u0110\u01a1n gi\u00e1<\/code> (Unit Cost)<\/li>\n<li>C\u1ed9t G: <code class=\"highlighter-rouge\">Th\u00e0nh ti\u1ec1n<\/code> (Total)<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<h2 id=\"s-dng-sql--lc-hay-truy-cp-d-liu-trong-bng-tnh\"><span class=\"ez-toc-section\" id=\"Su_dung_SQL_de_loc_hay_truy_cap_du_lieu_trong_bang_tinh\"><\/span>S\u1eed d\u1ee5ng SQL \u0111\u1ec3 l\u1ecdc hay truy c\u1eadp d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta nh\u01b0 th\u1ebf n\u00e0o, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong>SQL<\/strong> \u0111\u1ec3 truy c\u1eadp d\u1eef li\u1ec7u n\u00e0y v\u1edbi nh\u1eefng c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SQL<\/code>sau:<\/p>\n<h6 id=\"truy-cp-d-liu-t-bng-tnh-excel-bng-sql\"><span class=\"ez-toc-section\" id=\"Truy_cap_du_lieu_tu_bang_tinh_Excel_bang_SQL\"><\/span>Truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL<span class=\"ez-toc-section-end\"><\/span><\/h6>\n<ul>\n<li>Truy c\u1eadp to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh<\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>D\u1ea5u <code class=\"highlighter-rouge\">*<\/code> \u1edf trong c\u00e2u l\u1ec7nh n\u00e0y ngh\u0129a l\u00e0 ch\u00fang ta mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t. N\u1ebfu c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng file Excel trong video \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng c\u00e2u l\u1ec7nh SQL n\u00e0y, b\u1ea1n c\u1ea7n th\u00eam <code class=\"highlighter-rouge\">mi_sql<\/code> v\u00e0o \u0111\u1eb1ng tr\u01b0\u1edbc c\u00e2u l\u1ec7nh: <code class=\"highlighter-rouge\">mi_sql SELECT * FROM [A1:G20000]<\/code><\/p>\n<ul>\n<li>Truy c\u1eadp d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t s\u1ed1 c\u1ed9t nh\u1ea5t \u0111\u1ecbnh: ch\u00fang ta ghi t\u00ean c\u1ed9t ra sau t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">SELECT<\/code> v\u00e0 vi\u1ebft c\u00e1c c\u1ed9t ng\u0103n c\u00e1ch nhau b\u1eb1ng d\u1ea5u ph\u1ea9y <code class=\"highlighter-rouge\">,<\/code><\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"n\">OrderDate<\/span><span class=\"p\">,<\/span> <span class=\"n\">Region<\/span><span class=\"p\">,<\/span> <span class=\"n\">Rep<\/span><span class=\"p\">,<\/span> <span class=\"n\">Item<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h6 id=\"lc-d-liu-bng-tnh-excel-bng-sql\"><span class=\"ez-toc-section\" id=\"Loc_du_lieu_bang_tinh_Excel_bang_SQL\"><\/span>L\u1ecdc d\u1eef li\u1ec7u b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL<span class=\"ez-toc-section-end\"><\/span><\/h6>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel v\u1edbi 1 \u0111i\u1ec1u ki\u1ec7n: L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng t\u1eeb <code class=\"highlighter-rouge\">Hanoi<\/code><\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Region<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Hanoi'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>C\u00e2u l\u1ec7nh SQL tr\u00ean c\u00f3 ngh\u0129a l\u00e0: t\u1eeb v\u00f9ng d\u1eef li\u1ec7u <code class=\"highlighter-rouge\">A1:G20000<\/code>, l\u1ecdc ra nh\u1eefng d\u00f2ng m\u00e0 c\u1ed9t <code class=\"highlighter-rouge\">Region<\/code> c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 <code class=\"highlighter-rouge\">Hanoi<\/code><\/p>\n<blockquote>\n<p>T\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">WHERE<\/code> gi\u00fap ch\u00fang ta li\u1ec7t k\u00ea \u0111i\u1ec1u ki\u1ec7n khi l\u1ecdc d\u1eef li\u1ec7u.<\/p>\n<\/blockquote>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n: L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng t\u1eeb <code class=\"highlighter-rouge\">Hanoi<\/code> ho\u1eb7c <code class=\"highlighter-rouge\">Danang<\/code><\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Region<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Hanoi'<\/span>\r\n\t<span class=\"k\">OR<\/span> <span class=\"n\">Region<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Danang'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>C\u00e2u l\u1ec7nh SQL tr\u00ean c\u00f3 ngh\u0129a l\u00e0: t\u1eeb v\u00f9ng d\u1eef li\u1ec7u <code class=\"highlighter-rouge\">A1:G20000<\/code>, l\u1ecdc ra nh\u1eefng d\u00f2ng m\u00e0 c\u1ed9t <code class=\"highlighter-rouge\">Region<\/code> c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 <code class=\"highlighter-rouge\">Hanoi<\/code> ho\u1eb7c <code class=\"highlighter-rouge\">Danang<\/code><\/p>\n<p>Ngo\u00e0i c\u00e1ch d\u00f9ng t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">OR<\/code>, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">IN<\/code> v\u00e0 c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SQL<\/code> s\u1ebd nh\u01b0 sau:<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Region<\/span>\r\n\t<span class=\"k\">IN<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'Hanoi'<\/span><span class=\"p\">,<\/span><span class=\"s1\">'Danang'<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng b\u00e1n s\u1ea3n ph\u1ea9m <code class=\"highlighter-rouge\">Pencil<\/code> t\u1eeb <code class=\"highlighter-rouge\">Hanoi<\/code><\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Region<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Hanoi'<\/span>\r\n\t<span class=\"k\">AND<\/span> <span class=\"n\">Item<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Pencil'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>C\u00e2u l\u1ec7nh SQL tr\u00ean c\u00f3 ngh\u0129a l\u00e0: t\u1eeb v\u00f9ng d\u1eef li\u1ec7u <code class=\"highlighter-rouge\">A1:G20000<\/code>, l\u1ecdc ra nh\u1eefng d\u00f2ng m\u00e0 c\u1ed9t <code class=\"highlighter-rouge\">Region<\/code> c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 <code class=\"highlighter-rouge\">Hanoi<\/code> v\u00e0 c\u1ed9t <code class=\"highlighter-rouge\">Item<\/code> c\u00f3 gi\u00e1 tr\u1ecb l\u00e0<code class=\"highlighter-rouge\">Pencil<\/code>.<\/p>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng b\u00e1n s\u1ea3n ph\u1ea9m <code class=\"highlighter-rouge\">Pencil<\/code> t\u1eeb <code class=\"highlighter-rouge\">Hanoi<\/code> v\u00e0 ng\u01b0\u1eddi b\u00e1n l\u00e0 <code class=\"highlighter-rouge\">Jones<\/code><\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Region<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Hanoi'<\/span>\r\n\t<span class=\"k\">AND<\/span> <span class=\"n\">Item<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Pencil'<\/span>\r\n\t<span class=\"k\">AND<\/span> <span class=\"n\">Rep<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Jones'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng b\u00e1n s\u1ea3n ph\u1ea9m c\u00f3 \u0111\u01a1n gi\u00e1 (<code class=\"highlighter-rouge\">Unit Cost<\/code>) nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng $ 8.99<\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span> <span class=\"o\">&lt;=<\/span> <span class=\"mi\">8<\/span><span class=\"p\">.<\/span><span class=\"mi\">99<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p><strong>L\u01b0u \u00fd:<\/strong> Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c trong v\u00ed d\u1ee5 n\u00e0y, t\u00ean c\u1ed9t c\u1ee7a b\u1ea3ng t\u00ednh n\u00e0y l\u00e0 \u201cUnit Cost\u201d c\u00f3 d\u1ea5u c\u00e1ch \u1edf trong. T\u1ed1t nh\u1ea5t \u0111\u1ec3 tr\u00e1nh x\u1ea3y ra l\u1ed7i khi truy v\u1ea5n d\u1eef li\u1ec7u th\u00ec ch\u00fang ta kh\u00f4ng n\u00ean vi\u1ebft t\u00ean c\u1ed9t c\u00f3 d\u1ea5u c\u00e1ch ho\u1eb7c k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t (c\u00f3 ngh\u0129a l\u00e0 kh\u00f4ng vi\u1ebft t\u00ean c\u1ed9t b\u1eb1ng ti\u1ebfng Vi\u1ec7t c\u00f3 d\u1ea5u). {. :notice}<\/p>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng b\u00e1n s\u1ea3n ph\u1ea9m c\u00f3 \u0111\u01a1n gi\u00e1 (<code class=\"highlighter-rouge\">Unit Cost<\/code>) nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng $8.99 s\u1eafp x\u1ebfp t\u1eeb m\u1eb7t h\u00e0ng c\u00f3 \u0111\u01a1n gi\u00e1 \u0111\u1eaft nh\u1ea5t \u0111\u1ebfn m\u1eb7t h\u00e0ng c\u00f3 \u0111\u01a1n gi\u00e1 r\u1ebb nh\u1ea5t<\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span> <span class=\"o\">&lt;=<\/span> <span class=\"mi\">8<\/span><span class=\"p\">.<\/span><span class=\"mi\">99<\/span>\r\n\t<span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span> <span class=\"k\">DESC<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>\u1ede trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 thay <code class=\"highlighter-rouge\">[Unit Cost]<\/code> trong <code class=\"highlighter-rouge\">ORDER BY [Unit Cost] DESC<\/code> b\u1eb1ng m\u1ed9t c\u1ed9t kh\u00e1c. N\u1ebfu ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t c\u1ed9t l\u00e0 d\u1ea1ng chu\u1ed7i th\u00ec c\u1ed9t \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1eeb Z \u0111\u1ebfn A, n\u1ebfu ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t c\u1ed9t l\u00e0 d\u1ea1ng s\u1ed1 th\u00ec c\u1ed9t \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp nh\u1ecf d\u1ea7n.<\/p>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng b\u00e1n s\u1ea3n ph\u1ea9m c\u00f3 \u0111\u01a1n gi\u00e1 (<code class=\"highlighter-rouge\">Unit Cost<\/code>) l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng $8.99 s\u1eafp x\u1ebfp t\u1eeb m\u1eb7t h\u00e0ng c\u00f3 \u0111\u01a1n gi\u00e1 r\u1ebb nh\u1ea5t \u0111\u1ebfn m\u1eb7t h\u00e0ng c\u00f3 \u0111\u01a1n gi\u00e1 \u0111\u1eaft nh\u1ea5t<\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span> <span class=\"o\">&gt;=<\/span> <span class=\"mi\">8<\/span><span class=\"p\">.<\/span><span class=\"mi\">99<\/span>\r\n\t<span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>\u1ede \u0111\u00e2y, khi ch\u00fang ta s\u1eed d\u1ee5ng <code class=\"highlighter-rouge\">ORDER BY<\/code> v\u00e0 kh\u00f4ng ghi <code class=\"highlighter-rouge\">DESC<\/code> nh\u01b0 v\u00ed d\u1ee5 tr\u00ean th\u00ec SQL s\u1ebd t\u1ef1 \u0111\u1ed9ng s\u1eafp x\u1ebfp theo chi\u1ec1u thu\u1eadn ngh\u0129a l\u00e0 n\u1ebfu d\u1eef li\u1ec7u l\u00e0 chu\u1ed7i, th\u00ec s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1eeb A \u0111\u1ebfn Z, n\u1ebfu d\u1eef li\u1ec7u l\u00e0 s\u1ed1 th\u00ec s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n.<\/p>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u0111\u01a1n h\u00e0ng b\u00e1n s\u1ea3n ph\u1ea9m c\u00f3 \u0111\u01a1n gi\u00e1 (<code class=\"highlighter-rouge\">Unit Cost<\/code>) l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng $4.99 v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng $15.99<\/li>\n<\/ul>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span> <span class=\"o\">&gt;=<\/span> <span class=\"mi\">4<\/span><span class=\"p\">.<\/span><span class=\"mi\">99<\/span>\r\n\t<span class=\"k\">AND<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span> <span class=\"o\">&lt;=<\/span> <span class=\"mi\">15<\/span><span class=\"p\">.<\/span><span class=\"mi\">99<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>Ngo\u00e0i ra ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">BETWEEN<\/code> \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u trong kho\u1ea3ng gi\u00e1 tr\u1ecb<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">BETWEEN<\/span> <span class=\"mi\">4<\/span><span class=\"p\">.<\/span><span class=\"mi\">99<\/span> <span class=\"k\">AND<\/span> <span class=\"mi\">15<\/span><span class=\"p\">.<\/span><span class=\"mi\">99<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h3 id=\"download-ti-liu-km-theo-video-ti-y\"><span class=\"ez-toc-section\" id=\"Download_tai_lieu_kem_theo_video_tai_day\"><\/span>Download t\u00e0i li\u1ec7u k\u00e8m theo video t\u1ea1i \u0111\u00e2y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"https:\/\/www.dropbox.com\/s\/o3sftlsb6p2xcac\/Excel%2067%20SQL%20trong%20EXCEL_ductnguy.xlsm?dl=1\" target=\"_blank\" rel=\"noopener noreferrer\">Download excel file<\/a><\/p>\n<p>Hi\u1ec7n t\u1ea1i,\u00a0Blog H\u1ecdc Excel Online \u0111\u00e3 m\u1edf r\u1ea5t nhi\u1ec1u c\u00e1c kh\u00f3a h\u1ecdc \u0111\u00e0o t\u1ea1o v\u1ec1\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u1edbi c\u00e1c chuy\u00ean gia h\u00e0ng \u0111\u1ea7u t\u1ea1i Vi\u1ec7t Nam. Ch\u00fang t\u00f4i s\u1ebd mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng bu\u1ed5i h\u1ecdc b\u1ed5 \u00edch, hi\u1ec7u qu\u1ea3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o Excel \u0111\u1ec3 \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra, ch\u00fang t\u00f4i \u0111ang c\u00f3 nhi\u1ec1u ch\u01b0\u01a1ng tr\u00ecnh khuy\u1ebfn m\u1ea1i l\u1edbn cho c\u00e1c h\u1ecdc vi\u00ean \u0111\u0103ng k\u00ed trong th\u00e1ng n\u00e0y, v\u1eady c\u00f2n tr\u1ea7n tr\u1eeb g\u00ec n\u1eefa m\u00e0 kh\u00f4ng \u0111\u0103ng k\u00ed ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<h3 id=\"cc-kin-thc-lin-quan\"><\/h3>\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-354.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8912,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8911","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\/8911","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=8911"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8911\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8912"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}