{"id":8902,"date":"2024-12-29T06:00:15","date_gmt":"2024-12-29T06:00:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi-where\/"},"modified":"2024-12-29T06:00:15","modified_gmt":"2024-12-29T06:00:15","slug":"series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi-where","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi-where\/","title":{"rendered":"SERIES \u25b6 L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 2 \u2013 l\u1ecdc theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi WHERE"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong>N\u1ed9i dung ch\u00ednh<\/strong><\/p>\n<ul id=\"markdown-toc\">\n<li><a id=\"markdown-toc-nhng-v-d-v-lc-d-liu-theo-iu-kin-s-dng-where-trong-sql\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#nhng-v-d-v-lc-d-liu-theo-iu-kin-s-dng-where-trong-sql\">Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng WHERE trong SQL<\/a>\n<ul>\n<li><a id=\"markdown-toc-c-php-c-bn-ca-cu-lnh-sql-vi-where\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#c-php-c-bn-ca-cu-lnh-sql-vi-where\">1. C\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a c\u00e2u l\u1ec7nh SQL v\u1edbi WHERE<\/a><\/li>\n<li><a id=\"markdown-toc-lc-ra-nhng-dng-d-liu-m-c-ct-units-nhiu-hn-50\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#lc-ra-nhng-dng-d-liu-m-c-ct-units-nhiu-hn-50\">2. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t <code class=\"highlighter-rouge\">Units<\/code> nhi\u1ec1u h\u01a1n <code class=\"highlighter-rouge\">50<\/code><\/a><\/li>\n<li><a id=\"markdown-toc-lc-ra-nhng-dng-d-liu-m-c-ct-units-nhiu-hn-50-ca-nhn-vin-tn-jones-bn--hanoi\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#lc-ra-nhng-dng-d-liu-m-c-ct-units-nhiu-hn-50-ca-nhn-vin-tn-jones-bn--hanoi\">3. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t <code class=\"highlighter-rouge\">Units<\/code> nhi\u1ec1u h\u01a1n <code class=\"highlighter-rouge\">50<\/code>, c\u1ee7a nh\u00e2n vi\u00ean t\u00ean <code class=\"highlighter-rouge\">Jones<\/code> b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code>:<\/a><\/li>\n<li><a id=\"markdown-toc-lc-ra-nhng-dng-d-liu-m-sn-phm-c-bn--hanoi-hoc-dannang\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#lc-ra-nhng-dng-d-liu-m-sn-phm-c-bn--hanoi-hoc-dannang\">4. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> ho\u1eb7c <code class=\"highlighter-rouge\">Dannang<\/code>:<\/a><\/li>\n<li><a id=\"markdown-toc-lc-d-liu-ca-nhng-n-hng-bn-sn-phm-c-n-gi-unit-cost-nh-hn-hoc-bng-899\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#lc-d-liu-ca-nhng-n-hng-bn-sn-phm-c-n-gi-unit-cost-nh-hn-hoc-bng-899\">5. 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<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a id=\"markdown-toc-chng-ta--lm-g-trong-bi-vit-ny\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#chng-ta--lm-g-trong-bi-vit-ny\">Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<\/a><\/li>\n<li><a id=\"markdown-toc-download-ti-liu-km-theo-video\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#download-ti-liu-km-theo-video\">Download t\u00e0i li\u1ec7u k\u00e8m theo video<\/a><\/li>\n<li><a id=\"markdown-toc-cc-kin-thc-lin-quan\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html#cc-kin-thc-lin-quan\">C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan<\/a><\/li>\n<\/ul>\n<hr>\n<p>Trong b\u00e0i \u0111\u1ea7u ti\u00ean c\u1ee7a series <strong>L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel<\/strong>, c\u00e1c b\u1ea1n \u0111\u00e3 l\u00e0m quen v\u1edbi c\u1ea5u tr\u00fac b\u1ea3ng d\u1eef li\u1ec7u trong v\u00ed d\u1ee5 v\u00e0 c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SELECT<\/code> d\u00f9ng \u0111\u1ec3 truy v\u1ea5n d\u1eef li\u1ec7u. N\u1ebfu v\u00ec 1 l\u00fd do n\u00e0o \u0111\u00f3, b\u1ea1n \u0111\u1ebfn v\u1edbi b\u00e0i vi\u1ebft n\u00e0y m\u00e0 ch\u01b0a xem qua <a href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html\"><strong>ph\u1ea7n 1<\/strong><\/a>, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i \u1edf <a href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html\"><strong>\u0111\u00e2y<\/strong><\/a>. Ph\u1ea7n 2 c\u1ee7a series n\u00e0y s\u1ebd mang \u0111\u1ebfn cho c\u00e1c b\u1ea1n m\u1ed9t c\u00f4ng c\u1ee5 n\u1eefa khi s\u1eed d\u1ee5ng <code class=\"highlighter-rouge\">SQL<\/code> trong Excel, \u0111\u00f3 l\u00e0 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n.<\/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=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\"><strong>Download excel file k\u00e8m theo video<\/strong><\/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-6770e56e0a57f\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#Nhung_vi_du_ve_loc_du_lieu_theo_dieu_kien_su_dung_WHERE_trong_SQL\" title=\"Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng WHERE trong SQL\">Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng WHERE trong SQL<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#1_Cu_phap_co_ban_cua_cau_lenh_SQL_voi_WHERE\" title=\"1. C\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a c\u00e2u l\u1ec7nh SQL v\u1edbi WHERE\">1. C\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a c\u00e2u l\u1ec7nh SQL v\u1edbi WHERE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#2_Loc_ra_nhung_dong_du_lieu_ma_co_cot_Units_nhieu_hon_50\" title=\"2. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t Units nhi\u1ec1u h\u01a1n 50\">2. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t Units nhi\u1ec1u h\u01a1n 50<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#3_Loc_ra_nhung_dong_du_lieu_ma_co_cot_Units_nhieu_hon_50_cua_nhan_vien_ten_Jones_ban_o_Hanoi\" title=\"3. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t Units nhi\u1ec1u h\u01a1n 50, c\u1ee7a nh\u00e2n vi\u00ean t\u00ean Jones b\u00e1n \u1edf Hanoi:\">3. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t Units nhi\u1ec1u h\u01a1n 50, c\u1ee7a nh\u00e2n vi\u00ean t\u00ean Jones b\u00e1n \u1edf Hanoi:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#4_Loc_ra_nhung_dong_du_lieu_ma_san_pham_duoc_ban_o_Hanoi_hoac_Dannang\" title=\"4. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c b\u00e1n \u1edf Hanoi ho\u1eb7c Dannang:\">4. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c b\u00e1n \u1edf Hanoi ho\u1eb7c Dannang:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#5_Loc_du_lieu_cua_nhung_don_hang_ban_san_pham_co_don_gia_Unit_Cost_nho_hon_hoac_bang_899\" title=\"5. 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 (Unit Cost) nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng $8.99\">5. 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 (Unit Cost) nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng $8.99<\/a><\/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\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#Chung_ta_da_lam_gi_trong_bai_viet_nay\" title=\"Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?\">Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-2-loc-theo-dieu-kien-voi.html#Download_tai_lieu_kem_theo_video\" title=\"Download t\u00e0i li\u1ec7u k\u00e8m theo video\">Download t\u00e0i li\u1ec7u k\u00e8m theo video<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 id=\"nhng-v-d-v-lc-d-liu-theo-iu-kin-s-dng-where-trong-sql\"><span class=\"ez-toc-section\" id=\"Nhung_vi_du_ve_loc_du_lieu_theo_dieu_kien_su_dung_WHERE_trong_SQL\"><\/span>Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng WHERE trong SQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u00ean \u0111\u00e2y l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta:<\/p>\n<p style=\"text-align: center\"><\/p>\n<p>\u0110\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\"><strong>t\u1ea1i \u0111\u00e2y<\/strong><\/a><\/p>\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-834.gif\" title=\"ex101_92019-nho-834\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>http:\/\/www.hocexcel.online\/vba101-landing.html<\/p>\n<h4 id=\"c-php-c-bn-ca-cu-lnh-sql-vi-where\"><span class=\"ez-toc-section\" id=\"1_Cu_phap_co_ban_cua_cau_lenh_SQL_voi_WHERE\"><\/span>1. C\u00fa ph\u00e1p c\u01a1 b\u1ea3n c\u1ee7a c\u00e2u l\u1ec7nh SQL v\u1edbi WHERE<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"n\">column1<\/span><span class=\"p\">,<\/span> <span class=\"n\">column2<\/span><span class=\"p\">,<\/span> <span class=\"n\">columnN<\/span> \r\n\t<span class=\"k\">FROM<\/span> <span class=\"k\">table_name<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"p\">[<\/span><span class=\"n\">condition<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>Trong c\u00fa ph\u00e1p c\u01a1 b\u1ea3n n\u00e0y:<\/p>\n<ul>\n<li><code class=\"highlighter-rouge\">column1, column2, columnN<\/code> l\u00e0 t\u00ean c\u00e1c c\u1ed9t trong b\u1ea3ng t\u00ednh hay c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/li>\n<li><code class=\"highlighter-rouge\">table_name<\/code> l\u00e0 t\u00ean b\u1ea3ng t\u00ednh, ho\u1eb7c t\u00ean v\u00f9ng d\u1eef li\u1ec7u (Trong v\u00ed d\u1ee5, ch\u00fang ta l\u00e0m vi\u1ec7c v\u1edbi v\u00f9ng d\u1eef li\u1ec7u <code class=\"highlighter-rouge\">A1:G20000<\/code>)<\/li>\n<li><code class=\"highlighter-rouge\">[condition]<\/code> l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<h4 id=\"lc-ra-nhng-dng-d-liu-m-c-ct-units-nhiu-hn-50\"><span class=\"ez-toc-section\" id=\"2_Loc_ra_nhung_dong_du_lieu_ma_co_cot_Units_nhieu_hon_50\"><\/span>2. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t <code class=\"highlighter-rouge\">Units<\/code> nhi\u1ec1u h\u01a1n <code class=\"highlighter-rouge\">50<\/code><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SQL<\/code> sau \u0111\u00e2y:<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<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\">Units<\/span> <span class=\"o\">&gt;<\/span> <span class=\"mi\">50<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h4 id=\"lc-ra-nhng-dng-d-liu-m-c-ct-units-nhiu-hn-50-ca-nhn-vin-tn-jones-bn--hanoi\"><span class=\"ez-toc-section\" id=\"3_Loc_ra_nhung_dong_du_lieu_ma_co_cot_Units_nhieu_hon_50_cua_nhan_vien_ten_Jones_ban_o_Hanoi\"><\/span>3. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u00f3 c\u1ed9t <code class=\"highlighter-rouge\">Units<\/code> nhi\u1ec1u h\u01a1n <code class=\"highlighter-rouge\">50<\/code>, c\u1ee7a nh\u00e2n vi\u00ean t\u00ean <code class=\"highlighter-rouge\">Jones<\/code> b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code>:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<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\">Units<\/span> <span class=\"o\">&gt;<\/span> <span class=\"mi\">50<\/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\t<span class=\"k\">AND<\/span> <span class=\"n\">Region<\/span><span class=\"o\">=<\/span><span class=\"s1\">'Hanoi'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>Trong c\u00e2u l\u1ec7nh n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c, n\u1ebfu mu\u1ed1n l\u1ecdc d\u1ef1a tr\u00ean nhi\u1ec1u h\u01a1n 1 \u0111i\u1ec1u ki\u1ec7n th\u00ec gi\u1eefa c\u00e1c \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta s\u1eed d\u1ee5ng t\u1eeb kho\u00e1<code class=\"highlighter-rouge\">AND<\/code><\/p>\n<h4 id=\"lc-ra-nhng-dng-d-liu-m-sn-phm-c-bn--hanoi-hoc-dannang\"><span class=\"ez-toc-section\" id=\"4_Loc_ra_nhung_dong_du_lieu_ma_san_pham_duoc_ban_o_Hanoi_hoac_Dannang\"><\/span>4. L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> ho\u1eb7c <code class=\"highlighter-rouge\">Dannang<\/code>:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<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>Ngo\u00e0i c\u00e1ch s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 \u2018OR\u2019, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e2u <code class=\"highlighter-rouge\">SQL<\/code> sau, c\u0169ng s\u1ebd cho k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady:<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<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<h4 id=\"lc-d-liu-ca-nhng-n-hng-bn-sn-phm-c-n-gi-unit-cost-nh-hn-hoc-bng-899\"><span class=\"ez-toc-section\" id=\"5_Loc_du_lieu_cua_nhung_don_hang_ban_san_pham_co_don_gia_Unit_Cost_nho_hon_hoac_bang_899\"><\/span>5. 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<span class=\"ez-toc-section-end\"><\/span><\/h4>\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).<\/p>\n<h3 id=\"chng-ta--lm-g-trong-bi-vit-ny\"><span class=\"ez-toc-section\" id=\"Chung_ta_da_lam_gi_trong_bai_viet_nay\"><\/span>Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng, kh\u1ea3 n\u0103ng l\u1ecdc d\u1eef li\u1ec7u trong Excel c\u1ee7a SQL ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 tho\u1ea3 m\u00e3n to\u00e0n b\u1ed9 nhu c\u1ea7u l\u1ecdc d\u1eef li\u1ec7u d\u00f9 ph\u1ee9c t\u1ea1p \u0111\u1ebfn \u0111\u00e2u. C\u00f3 c\u00e2u h\u1ecfi g\u00ec b\u1ea1n \u0111ang th\u1eafc m\u1eafc? H\u00e3y comment l\u1ea1i ph\u00eda d\u01b0\u1edbi, ch\u00fang ta s\u1ebd c\u00f9ng gi\u1ea3i quy\u1ebft. H\u1eb9n g\u1eb7p l\u1ea1i \u1edf b\u00e0i sau v\u00e0 ch\u00fac m\u1ed9t ng\u00e0y l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3.<\/p>\n<p>Trong l\u00fac \u0111\u00f3, c\u00f3 th\u1ec3 c\u00e1c b\u1ea1n mu\u1ed1n xem c\u00e1c b\u00e0i ti\u1ebfp theo:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html\" target=\"_blank\">L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 3 \u2013 l\u1ecdc n\u00e2ng cao v\u1edbi LIKE<\/a><\/li>\n<li><a href=\"http:\/\/www.hocexcel.online\/2015\/11\/03\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-4.html\" target=\"_blank\">L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 4 \u2013 S\u1eed d\u1ee5ng Order By<\/a><\/li>\n<\/ul>\n<h3 id=\"download-ti-liu-km-theo-video\"><span class=\"ez-toc-section\" id=\"Download_tai_lieu_kem_theo_video\"><\/span>Download t\u00e0i li\u1ec7u k\u00e8m theo video<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\">Download excel file<\/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<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-834.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8903,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8902","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\/8902","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=8902"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8902\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8903"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}