{"id":12267,"date":"2023-01-29T07:30:16","date_gmt":"2023-01-29T07:30:16","guid":{"rendered":"https:\/\/www.webhozz.com\/blog\/?p=12267"},"modified":"2023-05-09T07:42:29","modified_gmt":"2023-05-09T07:42:29","slug":"memanggil-data-berurutan-secara-descending-2","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/","title":{"rendered":"Memanggil Data Berurutan Secara DESCENDING"},"content":{"rendered":"\n

Assalamualaikum Wr. Wb.<\/p>\n\n\n\n

Sahabat Webhozz dimanapun berada, semoga sehat dan bahagia selalu ya, Amin.<\/p>\n\n\n\n

Kali ini kita akan belajar bahasa SQL. Yaitu mengurutkan data secara DESCENDING.<\/p>\n\n\n\n

Descending itu apa sih?<\/p>\n\n\n\n

Oke, tentunya man teman pernah melihat data di toko online, status sosial media, berita online, dan lain sebagainya.<\/p>\n\n\n\n

Nah, biasanya postingan produk, status, atau berita yang akan tampil adalah data yang paling baru. Ya berita baru, status baru, produk baru. Ya seperti itu.<\/p>\n\n\n\n

Kan, kalo basicnya yang biasanya kita lakukan adalah tiap isi data lewat database MySQL, maka data akan tersimpan secara berurutan dari yang paling lama sampai data terbaru.<\/p>\n\n\n\n

Jadi, data lama itu paling atas dan yang baru itu paling bawah.<\/p>\n\n\n\n

Nah, seperti itu disebut ASCENDING. Kalo DESCENDING sebaliknya.<\/p>\n\n\n\n

Oke, untuk prakteknya langsung aja kita mulai.<\/p>\n\n\n\n

Misalkan kita sudah punya databasenya nih.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
  1. Nah, format querynya untuk urutan Descending adalah kayak gini. SELECT *FROM nama_tabelnya ORDER BY primary_keynya DESC<\/li>
  2. Sebagai contohnya, kita coba dengan tabel pada gambar di langkah 1. SELECT * FROM kontak ORDER BY id_kontak DESC<\/li>
  3. Maka beginilah hasilnya.<\/li><\/ol>\n\n\n\n
    • <\/li><\/ul>\n\n\n\n

      Begitulah, pada perintah di atas kita memerintahkan menampilkan data dari tabel berdasarkan kunci primernya yaitu id_kontak dalam urutan Descending.<\/p>\n\n\n\n

      Sebenarnya gak cuma kunci primernya aja sih, pake atribut lainnya juga bisa kayak nama_kontak dan lain sebagainya. Tergantung kebutuhan.<\/p>\n\n\n\n

      Nah, kira-kira begitulah caranya. Mudah banget kan???<\/p>\n\n\n\n

      Demikianlah, semoga bermanfaat ya\u2026Amin.<\/p>\n\n\n\n

      Wassalamualaikum Wr. Wb.<\/p>\n\n\n\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      Assalamualaikum Wr. Wb. Sahabat Webhozz dimanapun berada, semoga sehat dan bahagia selalu ya, Amin. Kali ini kita akan belajar bahasa SQL. Yaitu mengurutkan data secara<\/p>\n","protected":false},"author":1,"featured_media":9023,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[3915,3916,3912,3914,3911,3913],"class_list":["post-12267","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-belajar-web-programming","tag-belajar-php-mysql-memanggil-data-berurutan-secara-descending","tag-belajar-php-mysql-memanggil-data-berurutan-secara-descending-pemula","tag-kursus-php-mysql-memanggil-data-berurutan-secara-descending-bandung","tag-kursus-php-mysql-memanggil-data-berurutan-secara-descending-jakarta","tag-tutorial-php-mysql-memanggil-data-berurutan-secara-descending","tag-tutorial-php-mysql-memanggil-data-berurutan-secara-descending-pemula"],"yoast_head":"\nMemanggil Data Berurutan Secara DESCENDING - WebHozz Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Memanggil Data Berurutan Secara DESCENDING - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Assalamualaikum Wr. Wb. Sahabat Webhozz dimanapun berada, semoga sehat dan bahagia selalu ya, Amin. Kali ini kita akan belajar bahasa SQL. Yaitu mengurutkan data secara\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-29T07:30:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-09T07:42:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\"},\"headline\":\"Memanggil Data Berurutan Secara DESCENDING\",\"datePublished\":\"2023-01-29T07:30:16+00:00\",\"dateModified\":\"2023-05-09T07:42:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/\"},\"wordCount\":232,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"keywords\":[\"Belajar PHP MySQL Memanggil Data Berurutan Secara DESCENDING\",\"Belajar PHP MySQL Memanggil Data Berurutan Secara DESCENDING Pemula\",\"Kursus PHP MySQL Memanggil Data Berurutan Secara DESCENDING Bandung\",\"Kursus PHP MySQL Memanggil Data Berurutan Secara DESCENDING Jakarta\",\"Tutorial PHP MySQL Memanggil Data Berurutan Secara DESCENDING\",\"Tutorial PHP MySQL Memanggil Data Berurutan Secara DESCENDING Pemula\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/\",\"name\":\"Memanggil Data Berurutan Secara DESCENDING - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"datePublished\":\"2023-01-29T07:30:16+00:00\",\"dateModified\":\"2023-05-09T07:42:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"width\":750,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanggil-data-berurutan-secara-descending-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Memanggil Data Berurutan Secara DESCENDING\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"name\":\"WebHozz Blog\",\"description\":\"Kursus Web & Android di Jakarta Bandung\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\",\"name\":\"WebHozz\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"width\":442,\"height\":442,\"caption\":\"WebHozz\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Memanggil Data Berurutan Secara DESCENDING - WebHozz Blog","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:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/","og_locale":"en_US","og_type":"article","og_title":"Memanggil Data Berurutan Secara DESCENDING - WebHozz Blog","og_description":"Assalamualaikum Wr. Wb. Sahabat Webhozz dimanapun berada, semoga sehat dan bahagia selalu ya, Amin. Kali ini kita akan belajar bahasa SQL. Yaitu mengurutkan data secara","og_url":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/","og_site_name":"WebHozz Blog","article_published_time":"2023-01-29T07:30:16+00:00","article_modified_time":"2023-05-09T07:42:29+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef"},"headline":"Memanggil Data Berurutan Secara DESCENDING","datePublished":"2023-01-29T07:30:16+00:00","dateModified":"2023-05-09T07:42:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/"},"wordCount":232,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","keywords":["Belajar PHP MySQL Memanggil Data Berurutan Secara DESCENDING","Belajar PHP MySQL Memanggil Data Berurutan Secara DESCENDING Pemula","Kursus PHP MySQL Memanggil Data Berurutan Secara DESCENDING Bandung","Kursus PHP MySQL Memanggil Data Berurutan Secara DESCENDING Jakarta","Tutorial PHP MySQL Memanggil Data Berurutan Secara DESCENDING","Tutorial PHP MySQL Memanggil Data Berurutan Secara DESCENDING Pemula"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/","url":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/","name":"Memanggil Data Berurutan Secara DESCENDING - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","datePublished":"2023-01-29T07:30:16+00:00","dateModified":"2023-05-09T07:42:29+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/#primaryimage","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","width":750,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/memanggil-data-berurutan-secara-descending-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Memanggil Data Berurutan Secara DESCENDING"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/blog\/#website","url":"https:\/\/www.webhozz.com\/blog\/","name":"WebHozz Blog","description":"Kursus Web & Android di Jakarta Bandung","publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhozz.com\/blog\/#organization","name":"WebHozz","url":"https:\/\/www.webhozz.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","width":442,"height":442,"caption":"WebHozz"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=12267"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12267\/revisions"}],"predecessor-version":[{"id":12574,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12267\/revisions\/12574"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media\/9023"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=12267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=12267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=12267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}