SQL/Fundamental SQL Using SELECT Statement.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Fundamental SQL Using SELECT Statement.ipynb","private_outputs":true,"provenance":[],"toc_visible":true,"authorship_tag":"ABX9TyMGBJw/cwSJa3rLDFZu2M+x"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"markdown","metadata":{"id":"gg2gR15SV6Wy"},"source":["# [Mengambil Seluruh Kolom dalam suatu Tabel](https://academy.dqlab.id/main/livecode/213/385/1898)"]},{"cell_type":"code","metadata":{"id":"ahhXc_F7TQBb"},"source":["SELECT * FROM ms_produk;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"T85KXmWbWi2K"},"source":["# [Mengambil Satu Kolom dari Tabel](https://academy.dqlab.id/main/livecode/213/385/1899?pr=0)"]},{"cell_type":"code","metadata":{"id":"li_1-u20WsMB"},"source":["select nama_produk from ms_produk;\t"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"QkqC3qooWtR5"},"source":["# [Mengambil Lebih dari Satu Kolom dari Tabel](https://academy.dqlab.id/main/livecode/213/385/1901?pr=0)"]},{"cell_type":"code","metadata":{"id":"ZFicYhsvXD_p"},"source":["SELECT nama_produk, harga FROM ms_produk;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"um8Cvjh4XE1W"},"source":["# [Membatasi Pengambilan Jumlah Row Data](https://academy.dqlab.id/main/livecode/213/385/1903?pr=0)"]},{"cell_type":"code","metadata":{"id":"f9GU6oSXXS3B"},"source":["SELECT nama_produk, harga FROM ms_produk LIMIT 5;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"upxwIKK7XTk5"},"source":["# [Penggunaan SELECT DISTINCT statement](https://academy.dqlab.id/main/livecode/213/385/1988?pr=0)"]},{"cell_type":"code","metadata":{"id":"OBVsZCx8XcKu"},"source":["SELECT DISTINCT nama_customer, alamat FROM ms_pelanggan;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"QhAGtAfYX2TI"},"source":["# [Menggunakan Prefix pada Nama Kolom](https://academy.dqlab.id/main/livecode/213/386/1907?pr=0)"]},{"cell_type":"code","metadata":{"id":"jkj7uKLKX7tv"},"source":["SELECT ms_produk.kode_produk FROM ms_Produk;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"9ukocsAUX8Xm"},"source":["# [Menggunakan Alias pada Kolom](https://academy.dqlab.id/main/livecode/213/386/1909?pr=0)"]},{"cell_type":"code","metadata":{"id":"ttUDsRhYYEDp"},"source":["SELECT no_urut AS nomor, nama_produk AS nama FROM ms_produk;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"q-Hf3scPYEon"},"source":["# [Menghilangkan Keyword 'AS'](https://academy.dqlab.id/main/livecode/213/386/1911?pr=0)"]},{"cell_type":"code","metadata":{"id":"F8bDxHt_YNKQ"},"source":["SELECT no_urut nomor, nama_produk nama FROM ms_produk;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"81uJbm7KYNp1"},"source":["# [Menggabungkan Prefix dan Alias](https://academy.dqlab.id/main/livecode/213/386/1913?pr=0)"]},{"cell_type":"code","metadata":{"id":"XgSuAyJSYVmt"},"source":["SELECT ms_produk.harga AS harga_jual FROM ms_produk; "],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"zdcraRNUYWRz"},"source":["# [Menggunakan Alias pada Tabel](https://academy.dqlab.id/main/livecode/213/386/1914?pr=0)"]},{"cell_type":"code","metadata":{"id":"YpzHoWwkYcGy"},"source":["SELECT * FROM ms_produk t2;\t"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"Ny_9pe9ZYcnv"},"source":["# [Prefix dengan Alias Tabel](https://academy.dqlab.id/main/livecode/213/386/1915?pr=0)"]},{"cell_type":"code","metadata":{"id":"wX-Qe3bFYvbF"},"source":["SELECT t2.nama_produk, t2.harga FROM ms_produk t2"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"ZnGPkWvMY34A"},"source":["# [Menggunakan WHERE](https://academy.dqlab.id/main/livecode/213/387/1919?pr=0)"]},{"cell_type":"code","metadata":{"id":"UXEdAOb5Y9TE"},"source":["SELECT * FROM ms_produk WHERE nama_produk='Tas Travel Organizer DQLab';"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"bVRieP3iY-Ge"},"source":["# [Menggunakan Operand OR](https://academy.dqlab.id/main/livecode/213/387/1920?pr=0)"]},{"cell_type":"code","metadata":{"id":"8XlDWRP_ZF6n"},"source":["SELECT * FROM ms_produk WHERE nama_produk='Gantungan Kunci DQLab' OR nama_produk='Tas Travel Organizer DQLab'OR nama_produk='Flashdisk DQLab 64 GB' ;"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"MfahAXKOZG5X"},"source":["# [Filter untuk Angka](https://academy.dqlab.id/main/livecode/213/387/1921?pr=0)"]},{"cell_type":"code","metadata":{"id":"itEqOu4TZOdX"},"source":["SELECT * FROM ms_produk WHERE harga>50000;\t"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"9Pc_EZf3ZPGX"},"source":["# [Menggunakan Operand AND](https://academy.dqlab.id/main/livecode/213/387/1924?pr=0)"]},{"cell_type":"code","metadata":{"id":"QfOBh-qxZW_V"},"source":["SELECT * FROM ms_produk WHERE nama_produk='Gantungan Kunci DQLab' AND harga<50000;\t"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"0YTsTKtCZfbj"},"source":["# [Proyek dari Cabang A](https://academy.dqlab.id/main/livecode/213/388/1929?pr=0)"]},{"cell_type":"code","metadata":{"id":"bIkzQlNPZljb"},"source":["SELECT kode_pelanggan, nama_produk, qty, harga, qty*harga AS total FROM tr_penjualan WHERE qty*harga>=100000 ORDER BY total DESC;\t"],"execution_count":null,"outputs":[]}]}