{"id":1693,"date":"2023-07-25T08:49:49","date_gmt":"2023-07-25T08:49:49","guid":{"rendered":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/"},"modified":"2023-07-25T08:49:49","modified_gmt":"2023-07-25T08:49:49","slug":"permintaan-kueri-google-sheets-diurutkan-berdasarkan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/","title":{"rendered":"Kueri google spreadsheet: cara menggunakan sortir berdasarkan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengurutkan hasil kueri Google Sheets berdasarkan kolom tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">query<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">A1:C12<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">select A, B order by B asc<\/span> \", <span style=\"color: #3366ff;\">1<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, kita memilih kolom <strong>A<\/strong> dan <strong>B<\/strong> dan mengurutkan hasilnya berdasarkan kolom B dalam urutan menaik. Kami juga menentukan angka <strong>1<\/strong> untuk menunjukkan bahwa ada 1 baris header di bagian atas kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda juga dapat menggunakan sintaks berikut untuk mengurutkan berdasarkan beberapa kolom:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">query<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff9900;\">A1:C12<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">select A, B order by B asc, A desc<\/span> \", <span style=\"color: #3366ff;\">1<\/span> )<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, kita memilih kolom <strong>A<\/strong> dan <strong>B<\/strong> dan mengurutkan hasilnya berdasarkan kolom B menaik, lalu berdasarkan kolom A menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Urutkan dalam urutan kolom menaik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk memilih kolom Pemain dan Tim, lalu mengurutkan hasilnya berdasarkan Tim dalam urutan menaik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16694 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oq1.png\" alt=\"\" width=\"595\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Urutkan berdasarkan kolom menurun<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk memilih semua kolom dan mengurutkan hasilnya berdasarkan poin dalam urutan menurun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16695\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oq2.png\" alt=\"Urutan kueri Google Spreadsheet berdasarkan kolom\" width=\"655\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Urutkan berdasarkan beberapa kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk memilih semua kolom dan mengurutkan hasilnya terlebih dahulu berdasarkan tim menaik, lalu dengan poin menurun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16696\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oq3.png\" alt=\"Mengurutkan kueri Google Spreadsheet berdasarkan beberapa kolom\" width=\"660\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: pilih baris yang berisi string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\">Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengurutkan hasil kueri Google Sheets berdasarkan kolom tertentu: = query ( A1:C12 , &#8221; select A, B order by B asc &#8220;, 1 ) Dalam contoh ini, kita memilih kolom A dan B dan mengurutkan hasilnya berdasarkan kolom B dalam urutan menaik. Kami juga menentukan angka 1 untuk menunjukkan [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan klausa ORDER BY dalam query Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan klausa ORDER BY dalam query Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T08:49:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oq1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\",\"url\":\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\",\"name\":\"Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T08:49:49+00:00\",\"dateModified\":\"2023-07-25T08:49:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan klausa ORDER BY dalam query Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggunakan sortir berdasarkan\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan - Statorial","description":"Tutorial ini menjelaskan cara menggunakan klausa ORDER BY dalam query Google Sheets, dengan beberapa contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan klausa ORDER BY dalam query Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/","og_site_name":"Statorials","article_published_time":"2023-07-25T08:49:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/oq1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/","url":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/","name":"Kueri Google Spreadsheet: Cara Menggunakan Sortir Berdasarkan - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T08:49:49+00:00","dateModified":"2023-07-25T08:49:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan klausa ORDER BY dalam query Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggunakan sortir berdasarkan"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1693"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=1693"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1693\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}