{"id":1090,"date":"2022-05-16T13:27:15","date_gmt":"2022-05-16T13:27:15","guid":{"rendered":"https:\/\/www.sqlshare.com\/?page_id=1090"},"modified":"2022-05-16T13:52:58","modified_gmt":"2022-05-16T13:52:58","slug":"dasar-dasar-sql-server","status":"publish","type":"page","link":"https:\/\/www.sqlshare.com\/dasar-dasar-sql-server\/","title":{"rendered":"Dasar-dasar SQL Server"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1090\" class=\"elementor elementor-1090\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-dbc0ff4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dbc0ff4\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5acf00b\" data-id=\"5acf00b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-80a0b5f elementor-widget elementor-widget-spacer\" data-id=\"80a0b5f\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.14.0 - 26-06-2023 *\/\n.elementor-column .elementor-spacer-inner{height:var(--spacer-size)}.e-con{--container-widget-width:100%}.e-con-inner>.elementor-widget-spacer,.e-con>.elementor-widget-spacer{width:var(--container-widget-width,var(--spacer-size));--align-self:var(--container-widget-align-self,initial);--flex-shrink:0}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container,.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer,.e-con>.elementor-widget-spacer>.elementor-widget-container,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer{height:100%}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner{height:var(--container-widget-height,var(--spacer-size))}<\/style>\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3efb157 elementor-widget elementor-widget-heading\" data-id=\"3efb157\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.14.0 - 26-06-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Dasar-dasar SQL Server<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-09a7e9e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"09a7e9e\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-adee7d6\" data-id=\"adee7d6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8641311 elementor-widget elementor-widget-text-editor\" data-id=\"8641311\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.14.0 - 26-06-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h2>Bagian 1. Meminta data<\/h2><p>Bagian ini membantu Anda mempelajari cara membuat kueri data dari database SQL Server.\u00a0Kami akan mulai dengan kueri sederhana yang memungkinkan Anda mengambil data dari satu tabel.<\/p><p><a href=\"https:\/\/www.sqlshare.com\/\"><span>PILIH<\/span><\/a><span><a href=\"https:\/\/www.sqlshare.com\/\">\u00a0<\/a>\u00a0\u2013 menunjukkan cara mengkueri data terhadap satu tabe<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-d32ea71 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d32ea71\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-146e5c2\" data-id=\"146e5c2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-416aeec elementor-widget elementor-widget-spacer\" data-id=\"416aeec\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-5c73bec elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c73bec\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6d0d13d\" data-id=\"6d0d13d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ebf6219 elementor-widget elementor-widget-text-editor\" data-id=\"ebf6219\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 2. Menyortir data<\/span><\/h2><ul><li><span>ORDER BY<\/span><span>\u00a0\u00a0&#8211; mengurutkan hasil yang ditetapkan berdasarkan nilai dalam daftar kolom yang ditentukan<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-60d5e07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"60d5e07\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9ad4c2e\" data-id=\"9ad4c2e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-86c8e4f elementor-widget elementor-widget-spacer\" data-id=\"86c8e4f\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-2308812 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2308812\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-49be2cb\" data-id=\"49be2cb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6217721 elementor-widget elementor-widget-text-editor\" data-id=\"6217721\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 3. Membatasi baris<\/span><\/h2><ul><li><span>OFFSET FETCH<\/span><span>\u00a0\u2013 membatasi jumlah baris yang dikembalikan oleh kueri.<\/span><\/li><li><span>SELECT TOP<\/span><span>\u00a0\u2013 membatasi jumlah baris atau persentase baris yang dikembalikan dalam kumpulan hasil kueri.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-696f7de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"696f7de\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d4e69e8\" data-id=\"d4e69e8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9ba1a04 elementor-widget elementor-widget-spacer\" data-id=\"9ba1a04\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-391873a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"391873a\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2e8dd2c\" data-id=\"2e8dd2c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e835d9f elementor-widget elementor-widget-text-editor\" data-id=\"e835d9f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 4. Memfilter data<\/span><\/h2><ul><li><span>DISTINCT<\/span><span>\u00a0\u00a0\u2013 pilih nilai yang berbeda dalam satu atau lebih kolom tabel.<\/span><\/li><li><span>WHERE<\/span><span>\u00a0\u00a0\u2013 memfilter baris dalam output kueri berdasarkan satu atau beberapa kondisi.<\/span><\/li><li><span>AND<\/span><span>\u00a0\u00a0\u2013 menggabungkan dua ekspresi Boolean dan mengembalikan nilai true jika semua ekspresi benar.<\/span><\/li><li><span>ATAU<\/span><span>\u00a0\u2013 menggabungkan dua ekspresi Boolean dan mengembalikan nilai true jika salah satu dari kondisi tersebut benar.<\/span><\/li><li><span>IN<\/span><span>\u00a0\u00a0\u2013 periksa apakah suatu nilai cocok dengan nilai apa pun dalam daftar atau subkueri.<\/span><\/li><li><span>ANTARA<\/span><span>\u00a0\u00a0\u2013 menguji apakah suatu nilai berada di antara rentang nilai.<\/span><\/li><li><span>LIKE<\/span><span>\u00a0\u00a0\u2013 periksa apakah string karakter cocok dengan pola yang ditentukan.<\/span><\/li><li><span>Alias \u200b\u200bkolom &amp; tabel<\/span><span>\u00a0\u2013 menunjukkan cara menggunakan alias kolom untuk mengubah judul keluaran kueri dan alias tabel untuk meningkatkan keterbacaan kueri.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-d9592c3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d9592c3\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dd996fd\" data-id=\"dd996fd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f42298b elementor-widget elementor-widget-spacer\" data-id=\"f42298b\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-c5c88fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c5c88fc\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b7099b4\" data-id=\"b7099b4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c651b76 elementor-widget elementor-widget-text-editor\" data-id=\"c651b76\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 5. Bergabung dengan tabel<\/span><\/h2><ul><li><span>Bergabung<\/span><span>\u00a0\u2013 memberi Anda gambaran singkat tentang jenis gabungan di SQL Server termasuk gabungan dalam, gabungan kiri, gabungan kanan, dan gabungan luar penuh.<\/span><\/li><li><span><span class=\"\">INNER JOIN<\/span><\/span><span><span class=\"\">\u00a0\u00a0\u2013 pilih baris dari tabel yang memiliki baris yang cocok di tabel lain.<\/span><\/span><\/li><li><span>LEFT JOIN<\/span><span>\u00a0\u00a0\u2013 mengembalikan semua baris dari tabel kiri dan mencocokkan baris dari tabel kanan.\u00a0Jika tabel kanan tidak memiliki baris yang cocok, gunakan nilai nol untuk nilai kolom dari tabel kanan.<\/span><\/li><li><span>RIGHT JOIN<\/span><span>\u00a0\u2013 pelajari versi kebalikan dari left join.<\/span><\/li><li><span>FULL OUTER JOIN<\/span><span>\u00a0\u2013 mengembalikan baris yang cocok dari tabel kiri dan kanan, dan baris dari setiap sisi jika tidak ada baris yang cocok.<\/span><\/li><li><span>CROSS JOIN<\/span><span>\u00a0\u00a0\u2013 gabungkan beberapa tabel yang tidak terkait dan buat produk Cartesian dari baris di tabel yang digabungkan.<\/span><\/li><li><span>Gabung<\/span><span>\u00a0\u00a0mandiri \u2013 menunjukkan kepada Anda cara menggunakan gabung mandiri untuk mengkueri data hierarkis dan membandingkan baris dalam tabel yang sama.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-dd5d129 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd5d129\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1a3a692\" data-id=\"1a3a692\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1d50c5b elementor-widget elementor-widget-spacer\" data-id=\"1d50c5b\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-cdf9f8c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cdf9f8c\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ecbd68\" data-id=\"3ecbd68\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fbb0621 elementor-widget elementor-widget-text-editor\" data-id=\"fbb0621\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 6. Pengelompokan data<\/span><\/h2><ul><li><span>GROUP BY<\/span><span>\u00a0\u2013 mengelompokkan hasil kueri berdasarkan nilai dalam daftar ekspresi kolom yang ditentukan.<\/span><\/li><li><span>MEMILIKI<\/span><span>\u00a0\u2013 menentukan kondisi pencarian untuk grup atau agregat.<\/span><\/li><li><span>SET GROUPING<\/span><span>\u00a0\u2013 menghasilkan beberapa set pengelompokan.<\/span><\/li><li><span>CUBE<\/span><span>\u00a0\u2013 menghasilkan kumpulan pengelompokan dengan semua kombinasi kolom dimensi.<\/span><\/li><li><span>ROLLUP<\/span><span>\u00a0\u2013 menghasilkan set pengelompokan dengan asumsi hierarki antara kolom input.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-351aa57 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"351aa57\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6808345\" data-id=\"6808345\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c152e53 elementor-widget elementor-widget-spacer\" data-id=\"c152e53\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-42169ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"42169ea\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b86a3e5\" data-id=\"b86a3e5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d806784 elementor-widget elementor-widget-text-editor\" data-id=\"d806784\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 7. Subkueri<\/span><\/h2><p><span>Bagian ini berhubungan dengan subquery yang merupakan query bersarang dalam pernyataan lain seperti SELECT, INSERT, UPDATE atau DELETE pernyataan.<\/span><\/p><ul><li><span>Subquery<\/span><span>\u00a0\u00a0\u2013 menjelaskan konsep subquery dan menunjukkan cara menggunakan berbagai jenis subquery untuk memilih data.<\/span><\/li><li><span>Subquery berkorelasi<\/span><span>\u00a0\u2013 memperkenalkan Anda pada konsep subquery berkorelasi.<\/span><\/li><li><span>EXISTS<\/span><span>\u00a0\u00a0\u2013 menguji keberadaan baris yang dikembalikan oleh subquery.<\/span><\/li><li><span>APAPUN<\/span><span>\u00a0\u2013 membandingkan nilai dengan kumpulan nilai satu kolom yang dikembalikan oleh subkueri dan mengembalikan TRUE nilai yang cocok dengan nilai apa pun dalam kumpulan.<\/span><\/li><li><span>ALL<\/span><span>\u00a0\u2013 membandingkan nilai dengan kumpulan nilai satu kolom yang dikembalikan oleh subquery dan mengembalikan TRUE nilai yang cocok dengan semua nilai dalam kumpulan.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-a3fd02d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3fd02d\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c09d755\" data-id=\"c09d755\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a130238 elementor-widget elementor-widget-spacer\" data-id=\"a130238\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-97d7286 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"97d7286\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-28c6657\" data-id=\"28c6657\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c4867c elementor-widget elementor-widget-text-editor\" data-id=\"5c4867c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 8. Atur Operator<\/span><\/h2><p><span>Bagian ini memandu Anda menggunakan set operator termasuk union, intersect, dan kecuali untuk menggabungkan beberapa set hasil dari kueri input.<\/span><\/p><ul><li><span>UNION<\/span><span>\u00a0\u2013 menggabungkan kumpulan hasil dari dua atau lebih kueri menjadi satu kumpulan hasil.<\/span><\/li><li><span>INTERSECT<\/span><span>\u00a0\u2013 mengembalikan persimpangan set hasil dari dua atau lebih kueri.<\/span><\/li><li><span>KECUALI<\/span><span>\u00a0\u2013 temukan perbedaan antara dua kumpulan hasil dari dua kueri masukan.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-e9c858f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e9c858f\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7e1800b\" data-id=\"7e1800b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fb1182d elementor-widget elementor-widget-spacer\" data-id=\"fb1182d\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-0ee3922 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ee3922\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3a52beb\" data-id=\"3a52beb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0170946 elementor-widget elementor-widget-text-editor\" data-id=\"0170946\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 9. Ekspresi Tabel Umum (CTE)<\/span><\/h2><ul><li><span>CTE<\/span><span>\u00a0\u2013 gunakan ekspresi tabel umum untuk membuat kueri kompleks lebih mudah dibaca.<\/span><\/li><li><span>CTE rekursif<\/span><span>\u00a0\u2013 kueri data hierarkis menggunakan CTE rekursif.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-64b5001 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64b5001\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7d3f6ce\" data-id=\"7d3f6ce\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-afd4cf6 elementor-widget elementor-widget-spacer\" data-id=\"afd4cf6\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-717e241 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"717e241\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d4437ee\" data-id=\"d4437ee\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8d116e5 elementor-widget elementor-widget-text-editor\" data-id=\"8d116e5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 10. Pivot<\/span><\/h2><ul><li><span>PIVOT<\/span><span>\u00a0\u2013 mengonversi baris menjadi kolom<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-28c7a04 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28c7a04\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-43e5edd\" data-id=\"43e5edd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9bbcd3e elementor-widget elementor-widget-spacer\" data-id=\"9bbcd3e\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-688764e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"688764e\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-500ab97\" data-id=\"500ab97\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6591f4b elementor-widget elementor-widget-text-editor\" data-id=\"6591f4b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 11. Memodifikasi data<\/span><\/h2><p><span>Di bagian ini, Anda akan mempelajari cara mengubah konten tabel di database SQL Server.\u00a0Perintah SQL untuk memodifikasi data seperti menyisipkan, menghapus, dan memperbarui disebut sebagai bahasa manipulasi data (DML).<\/span><\/p><ul><li><span>INSERT<\/span><span>\u00a0\u00a0\u2013 menyisipkan baris ke dalam tabel<\/span><\/li><li><span>INSERT multiple rows<\/span><span>\u00a0\u2013 menyisipkan beberapa baris ke dalam tabel menggunakan satu pernyataan INSERT<\/span><\/li><li><span>INSERT INTO SELECT<\/span><span>\u00a0\u2013 memasukkan data ke dalam tabel dari hasil query.<\/span><\/li><li><span>UPDATE<\/span><span>\u00a0\u00a0\u2013 mengubah nilai yang ada dalam tabel.<\/span><\/li><li><span>UPDATE JOIN<\/span><span>\u00a0\u2013 perbarui nilai dalam tabel berdasarkan nilai dari tabel lain menggunakan klausa GABUNG.<\/span><\/li><li><span>DELETE<\/span><span>\u00a0\u00a0\u2013 menghapus satu atau lebih baris tabel.<\/span><\/li><li><span>MERGE<\/span><span>\u00a0\u2013 memandu Anda melalui langkah-langkah melakukan campuran penyisipan, pembaruan, dan penghapusan menggunakan satu pernyataan.<\/span><\/li><li><span>Transaksi<\/span><span>\u00a0\u2013 menunjukkan cara memulai transaksi secara eksplisit menggunakan pernyataan BEGIN TRANSACTION, COMMIT, dan ROLLBACK<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-6c66540 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6c66540\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d6d92d6\" data-id=\"d6d92d6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-667d5fb elementor-widget elementor-widget-spacer\" data-id=\"667d5fb\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-8544f69 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8544f69\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d69e9ff\" data-id=\"d69e9ff\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3201ccc elementor-widget elementor-widget-text-editor\" data-id=\"3201ccc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 12. Definisi data<\/span><\/h2><p><span>Bagian ini menunjukkan kepada Anda cara mengelola objek database yang paling penting termasuk database dan tabel.<\/span><\/p><ul><li><span>CREATE DATABASE<\/span><span>\u00a0\u2013 menunjukkan cara membuat database baru dalam contoh SQL Server menggunakan pernyataan CREATE DATABASE dan SQL Server Management Studio.<\/span><\/li><li><span>DROP DATABASE<\/span><span>\u00a0\u2013 pelajari cara menghapus database yang ada.<\/span><\/li><li><span>CREATE SCHEMA<\/span><span>\u00a0\u2013 menjelaskan cara membuat skema baru dalam database.<\/span><\/li><li><span>ALTER SCHEMA<\/span><span>\u00a0\u2013 tunjukkan cara mentransfer yang dapat diamankan dari skema ke skema lain dalam database yang sama.<\/span><\/li><li><span>DROP SCHEMA<\/span><span>\u00a0\u2013 pelajari cara menghapus skema dari database.<\/span><\/li><li><span>CREATE TABLE<\/span><span>\u00a0\u00a0\u2013 memandu Anda melalui langkah-langkah membuat tabel baru dalam skema database tertentu.<\/span><\/li><li><span>Kolom identitas<\/span><span>\u00a0\u2013 pelajari cara menggunakan properti IDENTITY untuk membuat kolom identitas untuk tabel.<\/span><\/li><li><span>Urutan<\/span><span>\u00a0\u2013 menjelaskan cara menghasilkan urutan nilai numerik berdasarkan spesifikasi.<\/span><\/li><li><span>ALTER TABLE TAMBAHKAN kolom<\/span><span>\u00a0\u2013 menunjukkan cara menambahkan satu atau lebih kolom ke tabel yang sudah ada<\/span><\/li><li><span>ALTER TABLE ALTER COLUMN<\/span><span>\u00a0\u2013 menunjukkan cara mengubah definisi kolom yang ada dalam tabel.<\/span><\/li><li><span>ALTER TABLE DROP COLUMN<\/span><span>\u00a0\u2013 pelajari cara menjatuhkan satu atau lebih kolom dari sebuah tabel.<\/span><\/li><li><span>Kolom<\/span><span>\u00a0yang dihitung \u2013 cara menggunakan kolom yang dihitung untuk melanjutkan logika perhitungan dalam beberapa kueri.<\/span><\/li><li><span>DROP TABLE<\/span><span>\u00a0\u00a0\u2013 menunjukkan cara menghapus tabel dari database.<\/span><\/li><li><span>TRUNCATE TABLE<\/span><span>\u00a0\u00a0\u2013 menghapus semua data dari tabel lebih cepat dan lebih efisien.<\/span><\/li><li><span>SELECT INTO<\/span><span>\u00a0\u2013 pelajari cara membuat tabel dan memasukkan data dari kueri ke dalamnya.<\/span><\/li><li><span>Mengganti nama tabel<\/span><span>\u00a0\u00a0\u2013 memandu Anda melalui proses mengganti nama tabel menjadi yang baru.<\/span><\/li><li><span>Tabel sementara<\/span><span>\u00a0\u2013 memperkenalkan Anda ke tabel sementara untuk menyimpan data langsung sementara dalam prosedur tersimpan atau sesi database.<\/span><\/li><li><span>Sinonim<\/span><span>\u00a0\u2013 menjelaskan sinonim dan menunjukkan cara membuat sinonim untuk objek database.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-ce9888b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce9888b\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ea1a0d0\" data-id=\"ea1a0d0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a58c5b0 elementor-widget elementor-widget-spacer\" data-id=\"a58c5b0\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-f0b0a06 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f0b0a06\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5895419\" data-id=\"5895419\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8709d25 elementor-widget elementor-widget-text-editor\" data-id=\"8709d25\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 13. Tipe Data SQL Server<\/span><\/h2><ul><li><span>Tipe data SQL Server<\/span><span>\u00a0\u00a0\u2013 memberi Anda gambaran umum tentang tipe data SQL Server bawaan.<\/span><\/li><li><span>BIT<\/span><span>\u00a0\u2013 menyimpan data bit yaitu, 0, 1, atau NULL dalam database dengan tipe data BIT.<\/span><\/li><li><span>INT<\/span><span>\u00a0\u2013 pelajari tentang berbagai tipe integer di SQL server termasuk BIGINT, INT, SMALLINT, dan TINYINT.<\/span><\/li><li><span>DECIMAL<\/span><span>\u00a0\u2013 menunjukkan cara menyimpan nilai numerik yang tepat dalam database dengan menggunakan tipe data DECIMAL atau NUMERIC.<\/span><\/li><li><span>CHAR<\/span><span>\u00a0\u2013 pelajari cara menyimpan string karakter non-Unicode dengan panjang tetap dalam database.<\/span><\/li><li><span>NCHAR<\/span><span>\u00a0\u2013 menunjukkan cara menyimpan string karakter Unicode dengan panjang tetap dan menjelaskan perbedaan antara\u00a0<\/span><code>CHAR<\/code><span>dan\u00a0<\/span><code>NCHAR<\/code><span>tipe data<\/span><\/li><li><span>VARCHAR<\/span><span>\u00a0\u2013 menyimpan data string non-Unicode dengan panjang variabel dalam database.<\/span><\/li><li><span>NVARCHAR<\/span><span>\u00a0\u2013 pelajari cara menyimpan data string Unicode dengan panjang variabel dalam sebuah tabel dan pahami perbedaan utama antara VARCHAR dan NVARCHAR.<\/span><\/li><li><span>DATETIME2<\/span><span>\u00a0\u2013 mengilustrasikan cara menyimpan data tanggal dan waktu dalam database.<\/span><\/li><li><span>TANGGAL<\/span><span>\u00a0\u00a0\u2013 diskusikan tipe data tanggal dan cara menyimpan tanggal dalam tabel.<\/span><\/li><li><span>TIME<\/span><span>\u00a0\u2013 menunjukkan cara menyimpan data waktu dalam database dengan menggunakan tipe data TIME.<\/span><\/li><li><span>DATETIMEOFFSET<\/span><span>\u00a0\u2013 menunjukkan cara memanipulasi datetime dengan zona waktu.<\/span><\/li><li><span>GUID<\/span><span>\u00a0\u2013 pelajari tentang GUID dan cara menggunakan fungsi NEWID() untuk menghasilkan nilai GUID.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-f811312 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f811312\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b597434\" data-id=\"b597434\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1bf130a elementor-widget elementor-widget-spacer\" data-id=\"1bf130a\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-f54e24d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f54e24d\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-21e5e2a\" data-id=\"21e5e2a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7839bf5 elementor-widget elementor-widget-text-editor\" data-id=\"7839bf5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 14. Batasan<\/span><\/h2><ul><li><span>Kunci utama<\/span><span>\u00a0\u00a0\u2013 menjelaskan kepada Anda konsep kunci utama dan menunjukkan kepada Anda cara menggunakan batasan kunci utama untuk mengelola kunci utama tabel.<\/span><\/li><li><span>Kunci asing<\/span><span>\u00a0\u2013 memperkenalkan Anda pada konsep kunci asing dan menunjukkan bahwa Anda menggunakan\u00a0<\/span><code>FOREIGN KEY<\/code><span>batasan untuk menerapkan tautan data dalam dua tabel.<\/span><\/li><li><span>NOT NULL constraint<\/span><span>\u00a0\u2013 menunjukkan cara memastikan kolom tidak menerima NULL.<\/span><\/li><li><span>Batasan UNIK<\/span><span>\u00a0\u00a0\u2013 memastikan bahwa data yang terdapat dalam kolom, atau sekelompok kolom, unik di antara baris dalam tabel.<\/span><\/li><li><span>PERIKSA kendala<\/span><span>\u00a0\u2013 memandu Anda melalui proses penambahan logika untuk memeriksa data sebelum menyimpannya dalam tabel.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-5bb943c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5bb943c\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4f879fa\" data-id=\"4f879fa\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2fb34c7 elementor-widget elementor-widget-spacer\" data-id=\"2fb34c7\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-7a78269 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7a78269\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8c91318\" data-id=\"8c91318\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a5c3dca elementor-widget elementor-widget-text-editor\" data-id=\"a5c3dca\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 15. Ekspresi<\/span><\/h2><ul><li><span>CASE<\/span><span>\u00a0\u2013 tambahkan logika if-else ke kueri SQL dengan menggunakan ekspresi CASE yang sederhana dan dicari.<\/span><\/li><li><span>COALESCE<\/span><span>\u00a0\u2013 menangani nilai NULL secara efektif menggunakan ekspresi COALESCE.<\/span><\/li><li><span>NULLIF<\/span><span>\u00a0\u2013 mengembalikan NULL jika kedua argumen sama;\u00a0jika tidak, kembalikan argumen pertama.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-cdc25fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cdc25fc\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e0103d1\" data-id=\"e0103d1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-733b40f elementor-widget elementor-widget-spacer\" data-id=\"733b40f\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-3fffcfa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3fffcfa\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-806dfe4\" data-id=\"806dfe4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d285cad elementor-widget elementor-widget-text-editor\" data-id=\"d285cad\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2><span>Bagian 16. Tips Berguna<\/span><\/h2><ul><li><span>Temukan duplikat<\/span><span>\u00a0\u2013 menunjukkan cara menemukan nilai duplikat dalam satu atau beberapa kolom tabel.<\/span><\/li><li><span>Hapus duplikat<\/span><span>\u00a0\u2013 jelaskan cara menghapus baris duplikat dari tabel.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Dasar-dasar SQL Server Bagian 1. Meminta data Bagian ini membantu Anda mempelajari cara membuat kueri data dari database SQL Server.\u00a0Kami akan mulai dengan kueri sederhana yang memungkinkan Anda mengambil data dari satu tabel. PILIH\u00a0\u00a0\u2013 menunjukkan cara mengkueri data terhadap satu tabe Bagian 2. Menyortir data ORDER BY\u00a0\u00a0&#8211; mengurutkan hasil yang ditetapkan berdasarkan nilai dalam daftar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1090","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.sqlshare.com\/wp-json\/wp\/v2\/pages\/1090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlshare.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlshare.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlshare.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlshare.com\/wp-json\/wp\/v2\/comments?post=1090"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlshare.com\/wp-json\/wp\/v2\/pages\/1090\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlshare.com\/wp-json\/wp\/v2\/media?parent=1090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}