{"id":8884,"date":"2024-12-29T05:56:28","date_gmt":"2024-12-29T05:56:28","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-4-su-dung-order-by\/"},"modified":"2024-12-29T05:56:28","modified_gmt":"2024-12-29T05:56:28","slug":"series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order-by","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-4-su-dung-order-by\/","title":{"rendered":"SERIES \u25b6 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"},"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-sp-xp-d-liu-theo-nhiu-ct-vi-order-by-trong-sql\" 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#nhng-v-d-v-sp-xp-d-liu-theo-nhiu-ct-vi-order-by-trong-sql\">Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u c\u1ed9t v\u1edbi Order By trong SQL<\/a>\n<ul>\n<li><a id=\"markdown-toc-th-no-l-sp-xp\" 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#th-no-l-sp-xp\">1. Th\u1ebf n\u00e0o l\u00e0 s\u1eafp x\u1ebfp<\/a><\/li>\n<li><a id=\"markdown-toc-c-php-ca-cu-sql-vi-order-by\" 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#c-php-ca-cu-sql-vi-order-by\">2. C\u00fa ph\u00e1p c\u1ee7a c\u00e2u SQL v\u1edbi Order By<\/a><\/li>\n<li><a id=\"markdown-toc-mt-s-v-d\" 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#mt-s-v-d\">3. M\u1ed9t s\u1ed1 v\u00ed d\u1ee5<\/a>\n<ul>\n<li><a id=\"markdown-toc-tm-cc-mt-hng-bn--hanoi-theo-doanh-s-gim-dn\" 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#tm-cc-mt-hng-bn--hanoi-theo-doanh-s-gim-dn\">T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> theo doanh s\u1ed1 gi\u1ea3m d\u1ea7n<\/a><\/li>\n<li><a id=\"markdown-toc-tm-cc-mt-hng-bn--hanoi-sp-xp-tn-nhn-vin-bn-hng-t-a-ti-z\" 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#tm-cc-mt-hng-bn--hanoi-sp-xp-tn-nhn-vin-bn-hng-t-a-ti-z\">T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng t\u1eeb A t\u1edbi Z<\/a><\/li>\n<li><a id=\"markdown-toc-tm-cc-mt-hng-bn--hanoi-sp-xp-tn-mt-hng-t-z-n-a-sp-xp-tn-nhn-vin-theo-th-t-a-n-z\" 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#tm-cc-mt-hng-bn--hanoi-sp-xp-tn-mt-hng-t-z-n-a-sp-xp-tn-nhn-vin-theo-th-t-a-n-z\">T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> s\u1eafp x\u1ebfp t\u00ean m\u1eb7t h\u00e0ng t\u1eeb Z \u0111\u1ebfn A, s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean theo th\u1ee9 t\u1ef1 A \u0111\u1ebfn Z<\/a><\/li>\n<\/ul>\n<\/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\/03\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-4.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\/03\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-4.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\/03\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-4.html#cc-kin-thc-lin-quan\">C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan<\/a><\/li>\n<\/ul>\n<hr>\n<p>Trong c\u00e1c b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <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>SELECT<\/strong><\/a> \u0111\u1ec3 truy v\u1ea5n d\u1eef li\u1ec7u, s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 <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-2.html\"><strong>WHERE<\/strong><\/a> \u0111\u1ec3 \u0111\u01b0a ra \u0111i\u1ec1u ki\u1ec7n l\u1ecdc d\u1eef li\u1ec7u v\u00e0 s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 <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\"><strong>LIKE<\/strong><\/a> \u0111\u1ec3 m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng l\u1ecdc d\u1eef li\u1ec7u khi k\u1ebft h\u1ee3p v\u1edbi <code class=\"highlighter-rouge\">WHERE<\/code>. C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng, d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo m\u1ed9t tr\u00ecnh t\u1ef1 n\u00e0o c\u1ea3, trong bay n\u00e0y, ch\u00fang ta s\u1ebd \u0111i s\u1eafp x\u1ebfp d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">Order By<\/code>.<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/-gsMj4seais?list=PLALCv46JuKELXd5Ie81UqaFqAfsoXQSQt&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe>\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-6770e48b446d1\" 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-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.html#Nhung_vi_du_ve_sap_xep_du_lieu_theo_nhieu_cot_voi_Order_By_trong_SQL\" title=\"Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u c\u1ed9t v\u1edbi Order By trong SQL\">Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u c\u1ed9t v\u1edbi Order By 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-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.html#1_The_nao_la_sap_xep\" title=\"1. Th\u1ebf n\u00e0o l\u00e0 s\u1eafp x\u1ebfp\">1. Th\u1ebf n\u00e0o l\u00e0 s\u1eafp x\u1ebfp<\/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-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.html#2_Cu_phap_cua_cau_SQL_voi_Order_By\" title=\"2. C\u00fa ph\u00e1p c\u1ee7a c\u00e2u SQL v\u1edbi Order By\">2. C\u00fa ph\u00e1p c\u1ee7a c\u00e2u SQL v\u1edbi Order By<\/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-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.html#3_Mot_so_vi_du\" title=\"3. M\u1ed9t s\u1ed1 v\u00ed d\u1ee5\">3. M\u1ed9t s\u1ed1 v\u00ed d\u1ee5<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.html#Tim_cac_mat_hang_ban_o_Hanoi_theo_doanh_so_giam_dan\" title=\"T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf Hanoi theo doanh s\u1ed1 gi\u1ea3m d\u1ea7n\">T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf Hanoi theo doanh s\u1ed1 gi\u1ea3m d\u1ea7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.html#Tim_cac_mat_hang_ban_o_Hanoi_sap_xep_ten_nhan_vien_ban_hang_tu_A_toi_Z\" title=\"T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf Hanoi s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng t\u1eeb A t\u1edbi Z\">T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf Hanoi s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng t\u1eeb A t\u1edbi Z<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.html#Tim_cac_mat_hang_ban_o_Hanoi_sap_xep_ten_mat_hang_tu_Z_den_A_sap_xep_ten_nhan_vien_theo_thu_tu_A_den_Z\" title=\"T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf Hanoi s\u1eafp x\u1ebfp t\u00ean m\u1eb7t h\u00e0ng t\u1eeb Z \u0111\u1ebfn A, s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean theo th\u1ee9 t\u1ef1 A \u0111\u1ebfn Z\">T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf Hanoi s\u1eafp x\u1ebfp t\u00ean m\u1eb7t h\u00e0ng t\u1eeb Z \u0111\u1ebfn A, s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean theo th\u1ee9 t\u1ef1 A \u0111\u1ebfn Z<\/a><\/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-8\" href=\"https:\/\/blog.hocexcel.online\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.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-9\" href=\"https:\/\/blog.hocexcel.online\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-4-su-dung-order.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-sp-xp-d-liu-theo-nhiu-ct-vi-order-by-trong-sql\"><span class=\"ez-toc-section\" id=\"Nhung_vi_du_ve_sap_xep_du_lieu_theo_nhieu_cot_voi_Order_By_trong_SQL\"><\/span>Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u c\u1ed9t v\u1edbi Order By 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\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-831.gif\" title=\"ex101_92019-nho-831\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4 id=\"th-no-l-sp-xp\"><span class=\"ez-toc-section\" id=\"1_The_nao_la_sap_xep\"><\/span>1. Th\u1ebf n\u00e0o l\u00e0 s\u1eafp x\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Tr\u01b0\u1edbc khi \u0111i v\u00e0o c\u00e1c v\u00ed d\u1ee5, n\u00f3i \u0111\u1ebfn s\u1eafp x\u1ebfp, ng\u01b0\u1eddi ta hi\u1ec3u g\u1ed3m c\u00f3 2 c\u00e1ch s\u1eafp x\u1ebfp c\u01a1 b\u1ea3n \u0111\u00f3 l\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n v\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n. V\u1edbi m\u1ed7i lo\u1ea1i d\u1eef li\u1ec7u th\u00ec vi\u1ec7c s\u1eafp x\u1ebfp n\u00e0y c\u00f3 \u00fd ngh\u0129a kh\u00e1c nhau. Ch\u00fang ta th\u01b0\u1eddng g\u1eb7p 2 ki\u1ec3u d\u1eef li\u1ec7u ch\u00ednh l\u00e0 ki\u1ec3u d\u1eef li\u1ec7u chu\u1ed7i (ch\u1eef c\u00e1i, t\u00ean \u0111\u1ecba danh, t\u00ean ng\u01b0\u1eddi, t\u00ean m\u1eb7t h\u00e0ng, \u2026) v\u00e0 d\u1eef li\u1ec7u c\u00f3 d\u1ea1ng s\u1ed1 (ng\u00e0y th\u00e1ng, s\u1ed1 ti\u1ec1n, s\u1ed1 l\u01b0\u1ee3ng, \u2026)<\/p>\n<ul>\n<li><code class=\"highlighter-rouge\">D\u1eef li\u1ec7u d\u1ea1ng s\u1ed1<\/code> : \u0111\u1ed1i v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y, s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n ngh\u0129a l\u00e0 s\u1eafp x\u1ebfp gi\u00e1 tr\u1ecb c\u1ee7a d\u1eef li\u1ec7u t\u0103ng d\u1ea7n, t\u1eeb s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t \u0111\u1ebfn s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. S\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n ngh\u0129a l\u00e0 s\u1eafp x\u1ebfp t\u1eeb s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t cho \u0111\u1ebfn s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.<\/li>\n<li><code class=\"highlighter-rouge\">D\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i k\u00ed t\u1ef1<\/code>: \u0111\u1ed1i v\u1edbi ki\u1ec3u d\u1eef li\u1ec7u n\u00e0y, s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n ngh\u0129a l\u00e0 s\u1eafp x\u1ebfp c\u00e1c t\u1eeb theo th\u1ee9 t\u1ef1 t\u1eeb A \u0111\u1ebfn Z, hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 s\u1eafp x\u1ebfp c\u00e1c t\u1eeb theo th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp trong t\u1eeb \u0111i\u1ec3n. S\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n \u0111\u1ed1i v\u1edbi <code class=\"highlighter-rouge\">d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i k\u00ed t\u1ef1<\/code> ngh\u0129a l\u00e0 s\u1eafp x\u1ebfp t\u1eeb Z t\u1edbi A.<\/li>\n<\/ul>\n<p>http:\/\/www.hocexcel.online\/vba101-landing.html<\/p>\n<h4 id=\"c-php-ca-cu-sql-vi-order-by\"><span class=\"ez-toc-section\" id=\"2_Cu_phap_cua_cau_SQL_voi_Order_By\"><\/span>2. C\u00fa ph\u00e1p c\u1ee7a c\u00e2u SQL v\u1edbi Order By<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00fa ph\u00e1p c\u1ee7a Order By khi s\u1eed d\u1ee5ng chung v\u1edbi <code class=\"highlighter-rouge\">SELECT<\/code> v\u00e0 <code class=\"highlighter-rouge\">WHERE<\/code> nh\u01b0 sau (Kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i s\u1eed d\u1ee5ng <code class=\"highlighter-rouge\">WHERE<\/code>, nh\u01b0ng \u1edf \u0111\u00e2y \u0111\u1ec3 minh ho\u1ea1 th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c t\u1eeb kho\u00e1, n\u00ean <code class=\"highlighter-rouge\">WHERE<\/code> \u0111\u01b0\u1ee3c cho v\u00e0o)<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"k\">c<\/span><span class=\"err\">\u1ed9<\/span><span class=\"n\">t_1<\/span><span class=\"p\">,<\/span> <span class=\"k\">c<\/span><span class=\"err\">\u1ed9<\/span><span class=\"n\">t_2<\/span><span class=\"p\">,<\/span> <span class=\"p\">...,<\/span><span class=\"k\">c<\/span><span class=\"err\">\u1ed9<\/span><span class=\"n\">t_N<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"n\">t<\/span><span class=\"err\">\u00ea<\/span><span class=\"n\">n_v<\/span><span class=\"err\">\u00f9<\/span><span class=\"n\">ng_d<\/span><span class=\"err\">\u1eef<\/span><span class=\"n\">_li<\/span><span class=\"err\">\u1ec7<\/span><span class=\"n\">u<\/span>\r\n\t<span class=\"p\">[<\/span><span class=\"k\">WHERE<\/span> <span class=\"err\">\u0111<\/span><span class=\"n\">i<\/span><span class=\"err\">\u1ec1<\/span><span class=\"n\">u_ki<\/span><span class=\"err\">\u1ec7<\/span><span class=\"n\">n<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"p\">[<\/span><span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"k\">c<\/span><span class=\"err\">\u1ed9<\/span><span class=\"n\">t_1<\/span><span class=\"p\">,<\/span> <span class=\"k\">c<\/span><span class=\"err\">\u1ed9<\/span><span class=\"n\">t2<\/span><span class=\"p\">,<\/span> <span class=\"p\">...,<\/span> <span class=\"k\">c<\/span><span class=\"err\">\u1ed9<\/span><span class=\"n\">t_N<\/span><span class=\"p\">]<\/span> <span class=\"p\">[<\/span><span class=\"k\">ASC<\/span> <span class=\"o\">|<\/span> <span class=\"k\">DESC<\/span><span class=\"p\">];<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>Gi\u1ea3i th\u00edch:<\/p>\n<ul>\n<li>Ph\u1ea7n c\u00e2u l\u1ec7nh \u0111\u01b0\u1ee3c vi\u1ebft trong d\u1ea5u ngo\u1eb7c vu\u00f4ng <code class=\"highlighter-rouge\">[]<\/code> l\u00e0 kh\u00f4ng b\u1eaft bu\u1ed9c, c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3.<\/li>\n<li>\u1ede trong <code class=\"highlighter-rouge\">[ORDER BY c\u1ed9t_1, c\u1ed9t2, ..., c\u1ed9t_N]<\/code>, vi\u1ec7c s\u1eafp x\u1ebfp c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n theo 1 c\u1ed9t, 2 c\u1ed9t, ho\u1eb7c nhi\u1ec1u c\u1ed9t tu\u1ef3 thu\u1ed9c v\u00e0o nhu c\u1ea7u<\/li>\n<li>Ph\u1ea7n <code class=\"highlighter-rouge\">[ASC | DESC]<\/code> ngh\u0129a l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft 1 trong 2 gi\u00e1 tr\u1ecb <code class=\"highlighter-rouge\">ASC<\/code> ngh\u0129a l\u00e0 s\u1eafp x\u1ebfp theo chi\u1ec1u thu\u1eadn, t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn, t\u1eeb A t\u1edbi Z; ng\u01b0\u1ee3c l\u1ea1i \u0111\u1ed1i v\u1edbi <code class=\"highlighter-rouge\">DESC<\/code>. M\u1eb7c \u0111\u1ecbnh, n\u1ebfu kh\u00f4ng c\u00f3 2 t\u1eeb n\u00e0y, th\u00ec vi\u1ec7c s\u1eafp x\u1ebfp \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n theo chi\u1ec1u thu\u1eadn.<\/li>\n<\/ul>\n<h4 id=\"mt-s-v-d\"><span class=\"ez-toc-section\" id=\"3_Mot_so_vi_du\"><\/span>3. M\u1ed9t s\u1ed1 v\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00e1c v\u00ed d\u1ee5 sau \u0111\u00e2y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n trong <a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\">file excel n\u00e0y<\/a> (H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng file excel \u1edf video ph\u00eda tr\u00ean)<\/p>\n<h5 id=\"tm-cc-mt-hng-bn--hanoi-theo-doanh-s-gim-dn\"><span class=\"ez-toc-section\" id=\"Tim_cac_mat_hang_ban_o_Hanoi_theo_doanh_so_giam_dan\"><\/span>T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> theo doanh s\u1ed1 gi\u1ea3m d\u1ea7n<span class=\"ez-toc-section-end\"><\/span><\/h5>\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\">Order<\/span> <span class=\"k\">By<\/span> <span class=\"n\">Total<\/span> <span class=\"k\">DESC<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>N\u1ebfu s\u1ebfp b\u1ea1n c\u1ea7n m\u1ed9t b\u00e1o c\u00e1o doanh s\u1ed1 c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 c\u00e2u l\u1ec7nh s\u1ebd t\u1ea1o ra b\u00e1o c\u00e1o \u0111\u00f3 cho b\u1ea1n.<\/p>\n<h5 id=\"tm-cc-mt-hng-bn--hanoi-sp-xp-tn-nhn-vin-bn-hng-t-a-ti-z\"><span class=\"ez-toc-section\" id=\"Tim_cac_mat_hang_ban_o_Hanoi_sap_xep_ten_nhan_vien_ban_hang_tu_A_toi_Z\"><\/span>T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng t\u1eeb A t\u1edbi Z<span class=\"ez-toc-section-end\"><\/span><\/h5>\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\">Order<\/span> <span class=\"k\">By<\/span> <span class=\"n\">Rep<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>Theo m\u1eb7c \u0111\u1ecbnh, khi ch\u00fang ta kh\u00f4ng vi\u1ebft chi\u1ec1u s\u1eafp x\u1ebfp v\u00e0o c\u00e2u l\u1ec7nh th\u00ec <code class=\"highlighter-rouge\">SQL<\/code>, d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1 s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo chi\u1ec1u thu\u1eadn (gi\u00e1 tr\u1ecb t\u0103ng d\u1ea7n v\u1edbi s\u1ed1, t\u1eeb A \u0111\u1ebfn Z v\u1edbi ch\u1eef).<\/p>\n<h5 id=\"tm-cc-mt-hng-bn--hanoi-sp-xp-tn-mt-hng-t-z-n-a-sp-xp-tn-nhn-vin-theo-th-t-a-n-z\"><span class=\"ez-toc-section\" id=\"Tim_cac_mat_hang_ban_o_Hanoi_sap_xep_ten_mat_hang_tu_Z_den_A_sap_xep_ten_nhan_vien_theo_thu_tu_A_den_Z\"><\/span>T\u00ecm c\u00e1c m\u1eb7t h\u00e0ng b\u00e1n \u1edf <code class=\"highlighter-rouge\">Hanoi<\/code> s\u1eafp x\u1ebfp t\u00ean m\u1eb7t h\u00e0ng t\u1eeb Z \u0111\u1ebfn A, s\u1eafp x\u1ebfp t\u00ean nh\u00e2n vi\u00ean theo th\u1ee9 t\u1ef1 A \u0111\u1ebfn Z<span class=\"ez-toc-section-end\"><\/span><\/h5>\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\">Order<\/span> <span class=\"k\">By<\/span> <span class=\"n\">Item<\/span> <span class=\"k\">DESC<\/span><span class=\"p\">,<\/span> <span class=\"n\">Rep<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>C\u00e2u <code class=\"highlighter-rouge\">SQL<\/code> tr\u00ean s\u1ebd s\u1eafp x\u1ebfp m\u1ecdi k\u1ebft qu\u1ea3 theo t\u00ean m\u1eb7t h\u00e0ng <code class=\"highlighter-rouge\">Item<\/code> t\u1eeb Z \u0111\u1ebfn A; n\u1ebfu c\u00f3 1 hay nhi\u1ec1u m\u1eb7t h\u00e0ng c\u00f3 t\u00ean gi\u1ed1ng nhau, c\u1ed9t t\u00ean nh\u00e2n vi\u00ean s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb A \u0111\u1ebfn Z.<\/p>\n<p>Tham kh\u1ea3o th\u00eam <a href=\"http:\/\/stackoverflow.com\/questions\/2051162\/sql-multiple-column-ordering\">Stackoverflow \u2013 sql multiple column ordering<\/a><\/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 n\u00e0y, ch\u00fang ta l\u1ea1i m\u1ed9t b\u01b0\u1edbc n\u1eefa ti\u1ebfn g\u1ea7n h\u01a1n \u0111\u1ebfn vi\u1ec7c l\u00e0m ch\u1ee7 m\u1ed9t c\u00f4ng c\u1ee5 m\u1edbi \u2013 <code class=\"highlighter-rouge\">SQL<\/code> \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c c\u1ee7a ch\u00fang ta. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc \u0111\u1ebfn \u0111\u00e2y &amp; h\u1eb9n g\u1eb7p l\u1ea1i l\u1ea7n sau.<\/p>\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<p>http:\/\/www.hocexcel.online\/vba101-landing.html<\/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-831.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8885,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8884","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\/8884","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=8884"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8884\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8885"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}