tag:blogger.com,1999:blog-84993651864635862842024-03-05T09:10:25.287-08:00praktek SQL serverAngga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8499365186463586284.post-19953419948903780852017-05-23T02:23:00.004-07:002017-05-23T02:23:58.417-07:00TUGAS 7 SQL SERVERKita sekarang akan menambahkan tabel retur_jual<br />
seperti tutorial saya yang sebelumnya<br />
langsung saja kita akan mengisi datanya<br />
<ol>
<li>isi data <br /> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLpa2cuWsXdKd_Ch841GmaUWSfecU1-D6F2_PTkgYoxwfl5GK6qNeeWuPkRJUFhWJqGCPXUtrrdeOZ8QVT81XzSHqFP_zMuyz1JgQTtiGHpl-Nm6HEvYcc2uA03HI6ueHtmk1K42oaZMw/s1600/1.isi+data.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLpa2cuWsXdKd_Ch841GmaUWSfecU1-D6F2_PTkgYoxwfl5GK6qNeeWuPkRJUFhWJqGCPXUtrrdeOZ8QVT81XzSHqFP_zMuyz1JgQTtiGHpl-Nm6HEvYcc2uA03HI6ueHtmk1K42oaZMw/s1600/1.isi+data.PNG" /></a></div>
</li>
<li>update stok dengan matematika<br /> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7fQdc8GHq4i_kvyB-vGr6xR9mdA2v9YBR1-ActyCE7VV-rhsRr8x5Kx1RfOn_GlVbdaih7C_P4pwhG3hAfSFhUN25wJIagxaM3AikQR5X5FilpTsNtbUnNMAGm9o93NXjl_w_ImOokS4/s1600/2.update+stok+dengan+matematika.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7fQdc8GHq4i_kvyB-vGr6xR9mdA2v9YBR1-ActyCE7VV-rhsRr8x5Kx1RfOn_GlVbdaih7C_P4pwhG3hAfSFhUN25wJIagxaM3AikQR5X5FilpTsNtbUnNMAGm9o93NXjl_w_ImOokS4/s1600/2.update+stok+dengan+matematika.PNG" /></a></div>
</li>
<li>tambah 5 data retur<br /> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXsD00hiAmnwfrzrRCvSS2_R2DC-wX0-Pse8dylItrMUksdS8s5h5H0bMYXKI0wqQfzJSgydn_EjOsBUnBdqsGuBSWSuBEfFCSgitE3aOsFzLx0dF5J4Vz1-ds2eXncCnECl0mJBiRcDk/s1600/3.tambah+5+data+retur.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXsD00hiAmnwfrzrRCvSS2_R2DC-wX0-Pse8dylItrMUksdS8s5h5H0bMYXKI0wqQfzJSgydn_EjOsBUnBdqsGuBSWSuBEfFCSgitE3aOsFzLx0dF5J4Vz1-ds2eXncCnECl0mJBiRcDk/s1600/3.tambah+5+data+retur.PNG" /></a></div>
</li>
<li>update 3 data retur<br /> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidUfnkuhxxsEuck9FluU4L5bY4IUSGTloD9M8Nal5RAYdzI0mp8PU-XzBKxPzDzS-7HEh1u09wPelomQ0wHG9kTI4uhLImbI0T1CD8zjvCfGyq9YJ9pN6-pKi-brclIub2Jnt9LQilEhY/s1600/4.update+3+data+retur.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidUfnkuhxxsEuck9FluU4L5bY4IUSGTloD9M8Nal5RAYdzI0mp8PU-XzBKxPzDzS-7HEh1u09wPelomQ0wHG9kTI4uhLImbI0T1CD8zjvCfGyq9YJ9pN6-pKi-brclIub2Jnt9LQilEhY/s1600/4.update+3+data+retur.PNG" /></a></div>
</li>
<li>hapus 1 fild<br /> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWJvtU8dGo_1RRZPm5mXg8hB6O74rpPRrjtc5TXH7caXB69AxD2FO6Y0R3W3F_EU4ubz0X4ViUiBLwXeSyou85Ri4f3st3uwBJbEsoSKt00KSOoJ49NLo9fzVGukzV8E-j1YuMOwJX9dU/s1600/5.hapus+1+fild.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWJvtU8dGo_1RRZPm5mXg8hB6O74rpPRrjtc5TXH7caXB69AxD2FO6Y0R3W3F_EU4ubz0X4ViUiBLwXeSyou85Ri4f3st3uwBJbEsoSKt00KSOoJ49NLo9fzVGukzV8E-j1YuMOwJX9dU/s1600/5.hapus+1+fild.PNG" /></a></div>
</li>
<li>tambahkan kolom jenis_paket<br /> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDERKR9zLO2y9zasABIScw3AU8GuO6Ix3QPkt9NjwSxZ4kW-qgTEhtoiaCo0Y5nHJUFWYR0mDMedUKZIorjuG5Jh4ZvXqrWxzu8seQk5zdQFjfSDi4E2GjT9Va_JVAuBfHuoWvQ4Pq2eA/s1600/6.tambahkan+jenis_paket.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDERKR9zLO2y9zasABIScw3AU8GuO6Ix3QPkt9NjwSxZ4kW-qgTEhtoiaCo0Y5nHJUFWYR0mDMedUKZIorjuG5Jh4ZvXqrWxzu8seQk5zdQFjfSDi4E2GjT9Va_JVAuBfHuoWvQ4Pq2eA/s1600/6.tambahkan+jenis_paket.PNG" /></a></div>
</li>
<li>isi jenis paket<br /> <div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0ffJ_p6soAANiTcalYAfN5WL5gichsPZHybAQX1Hm7DRYnO42WUqKgdSN68hVw7ZTwYLO3nyetudOWVg-Vu8qwKriotMgwVLA55QcN7FOPafbNVtt0ZNg2TxM0vBfe9_zEThBMdO4UcU/s1600/7.isi+jenis+paket.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0ffJ_p6soAANiTcalYAfN5WL5gichsPZHybAQX1Hm7DRYnO42WUqKgdSN68hVw7ZTwYLO3nyetudOWVg-Vu8qwKriotMgwVLA55QcN7FOPafbNVtt0ZNg2TxM0vBfe9_zEThBMdO4UcU/s1600/7.isi+jenis+paket.PNG" /> </a></div>
<div class="separator" style="clear: both; text-align: left;">
sekian pertemuan kali ini </div>
</li>
</ol>
Angga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-20204464969863552422017-05-02T11:52:00.000-07:002017-05-02T11:52:22.769-07:00TUGAS kelompok sql server<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->1.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">1.</span><span style="font-size: 7pt; font-stretch: normal; line-height: normal;"> </span>Tampilan awal login aplikasi yang diisi admin</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5MLxnnI2M4px6RZzuDIaJPbtSOs8_tkFGCotnPF0O2XCbIrLG67ahGu3TZhvtBh0JdccYMzDMbMl9psy88pFfdh43yQpKrM0_z5mjWxcjtN4g2DV8h-pOou474EsCAYnbTnS3b38NrIQ/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5MLxnnI2M4px6RZzuDIaJPbtSOs8_tkFGCotnPF0O2XCbIrLG67ahGu3TZhvtBh0JdccYMzDMbMl9psy88pFfdh43yQpKrM0_z5mjWxcjtN4g2DV8h-pOou474EsCAYnbTnS3b38NrIQ/s320/1.png" width="320" /></a></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->2.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">2.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><!--[endif]-->Tampilan dashboard pada aplikasi<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguSKe4OdEOQ4fcGbS0OSGW5KM7OGSiO1sDTaLjXO_6e_pJrGjKcAnmGIvLTA04KX-1pzDS-pWvbkus1640wEb3FEeHdVIs6gjeV21zaakgR2qa042o1uQIKjVWLDlJqrRDH7C41o_YdUg/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguSKe4OdEOQ4fcGbS0OSGW5KM7OGSiO1sDTaLjXO_6e_pJrGjKcAnmGIvLTA04KX-1pzDS-pWvbkus1640wEb3FEeHdVIs6gjeV21zaakgR2qa042o1uQIKjVWLDlJqrRDH7C41o_YdUg/s1600/2.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<br />
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->3.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">3.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><!--[endif]-->Tampilan data barang yang terdapat tambah, edit,
hapus barang</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCtRcVjn9gh-lLorTDNOp0yeEc0Z9efkz06EoqzY-ycsPMRQovt7o71GWePQXAlq4X6NEw2ZyprmwSd9X14-VXHB0vRPIdYrADRJ8PKWTChw8xhdt5jTAry3flnu94WTENWekauWhfRtQ/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCtRcVjn9gh-lLorTDNOp0yeEc0Z9efkz06EoqzY-ycsPMRQovt7o71GWePQXAlq4X6NEw2ZyprmwSd9X14-VXHB0vRPIdYrADRJ8PKWTChw8xhdt5jTAry3flnu94WTENWekauWhfRtQ/s1600/3.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->4.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">4.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><!--[endif]-->Jika ingin menambahkan data barang klik ikon
tambah barang, yang terdapat pengisian data sebagai berikut</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-CKrXV2RSrMb9U1gru25Iai7Z6Ra3qHwW8rlW2D_YlMYuBauLaFvNGeDBnMyaxdojz0t0IHkumZuNDmsc0sg12BMMeo6v9vGi0R2t-O8tjrDmk2wS_1BgE-RabteTpS9nIVvamDlkED0/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-CKrXV2RSrMb9U1gru25Iai7Z6Ra3qHwW8rlW2D_YlMYuBauLaFvNGeDBnMyaxdojz0t0IHkumZuNDmsc0sg12BMMeo6v9vGi0R2t-O8tjrDmk2wS_1BgE-RabteTpS9nIVvamDlkED0/s1600/4.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->5.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">5.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><!--[endif]-->Jika ingin mengedit pada data barang klik ikon
edit yang akan menampilkan edit pada barang</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV93t2LuiQhewtOPArTEmiA0P9ue1LiPEbTJUy2QRTl0J_cCjdbfY2WsR1tv1MArworxZNhbpihU9RtTPMEoUquKPMoz_rh7WuLpfPb3X-p_tnwtfjXIv6vbuFOI1j4vO7PILn9tisgFg/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV93t2LuiQhewtOPArTEmiA0P9ue1LiPEbTJUy2QRTl0J_cCjdbfY2WsR1tv1MArworxZNhbpihU9RtTPMEoUquKPMoz_rh7WuLpfPb3X-p_tnwtfjXIv6vbuFOI1j4vO7PILn9tisgFg/s1600/5.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->6.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">6.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Jika ingin menghapus data barang klik ikon hapus
yang akan menampilkan pertanyaan apakah data akan dihapus</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja8-1tGWsKTg20Ijb-JN0veFZUP4vm3owD3Cbs0xVqa4Q3bzMEf1yfYZ12LM86JnNQ_dV7WY-hRcnv_x3fhgYXhpy7hatXPikhqQ9ELXGS2KHrm2Xfdde2vulQf1kpxF7GvOxK7hTI838/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja8-1tGWsKTg20Ijb-JN0veFZUP4vm3owD3Cbs0xVqa4Q3bzMEf1yfYZ12LM86JnNQ_dV7WY-hRcnv_x3fhgYXhpy7hatXPikhqQ9ELXGS2KHrm2Xfdde2vulQf1kpxF7GvOxK7hTI838/s1600/6.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->7.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">7.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Tampilan data supplier yang terdapat tambah,
edit, hapus supplier</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi3uQpDwITR0SKKBPGDS1cMKEjJy59TEivFO2XiNnqcnqw8i-zoL5p5yUk6irG6TKAq1KeCdArtJY6aCfK9Gl_8a8JyKUqUngcGBfhHMttlwylMevoSr8zi-lj7gCVEay1WMo8-OhjnU/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi3uQpDwITR0SKKBPGDS1cMKEjJy59TEivFO2XiNnqcnqw8i-zoL5p5yUk6irG6TKAq1KeCdArtJY6aCfK9Gl_8a8JyKUqUngcGBfhHMttlwylMevoSr8zi-lj7gCVEay1WMo8-OhjnU/s1600/7.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->8.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">8.</span>Jika ingin menambahkan data supplier klik ikon
tambah data supplier, yang terdapat pengisian data sebagai berikut</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWbbgw2nUoeEaP5ZHzn-x7cOhVhKt7cYrrmP3-a0NxF7wLpSr3_9rU4qiZAEh012v__6qsTSXM7zEbmgH34dUy6m08YTSwIg3NJ6-GqL7hZdsO3lfGwfMCUYZLJKHSYJ6Z_o0kMinivkQ/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWbbgw2nUoeEaP5ZHzn-x7cOhVhKt7cYrrmP3-a0NxF7wLpSr3_9rU4qiZAEh012v__6qsTSXM7zEbmgH34dUy6m08YTSwIg3NJ6-GqL7hZdsO3lfGwfMCUYZLJKHSYJ6Z_o0kMinivkQ/s1600/8.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->9.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;">9.</span><!--[endif]-->Jika ingin mengedit pada data supplier klik ikon
edit yang akan menampilkan edit pada supplier</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIFHbnBN5ZuFN0M0xCWfInUPA6bdPpUbdNu4Bvu4WTGAQ47Kjf0bu4fF5c3i79Ki2m8p185LctjHVM6jbXymBXqeuqVXrzWYXIXqbWxh30bZmlbPNUOabXTPvNfygHGMro3zyFrH5LATs/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIFHbnBN5ZuFN0M0xCWfInUPA6bdPpUbdNu4Bvu4WTGAQ47Kjf0bu4fF5c3i79Ki2m8p185LctjHVM6jbXymBXqeuqVXrzWYXIXqbWxh30bZmlbPNUOabXTPvNfygHGMro3zyFrH5LATs/s1600/9.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
10.Jika ingin menghapus data supplier klik ikon
hapus yang akan menampilkan pertanyaan apakah data akan dihapus</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJVRu54Ky-cg54gaXv29-jcDWAtLHAUi08Y5zucE02cltb_Ylowsg2-me95PHjLZH8Z08tLoMe02Dxq0cyqBq_zS2RaTwPk0zmBUnCnMXRu4-smr-Pq860DsM82svsanjFvbvOTaJx0MM/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJVRu54Ky-cg54gaXv29-jcDWAtLHAUi08Y5zucE02cltb_Ylowsg2-me95PHjLZH8Z08tLoMe02Dxq0cyqBq_zS2RaTwPk0zmBUnCnMXRu4-smr-Pq860DsM82svsanjFvbvOTaJx0MM/s1600/10.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
11.Tampilan data pembelian yang terdapat tambah,
edit, hapus pembelian</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdv597MaKRmmZgRa_1ljBfWBe-9Y68yOdJdllNO1kX7nBaVmlc0QPhMdkbI2XK0HlwhqTS8U9klk0lvxIrxxvWS24Hghvf2Ph1MjM7cwzbBoWtQVGZgBUMAqyMyQVrlRIuuppoKf2rgyA/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdv597MaKRmmZgRa_1ljBfWBe-9Y68yOdJdllNO1kX7nBaVmlc0QPhMdkbI2XK0HlwhqTS8U9klk0lvxIrxxvWS24Hghvf2Ph1MjM7cwzbBoWtQVGZgBUMAqyMyQVrlRIuuppoKf2rgyA/s1600/11.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> 12.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><!--[endif]-->Jika ingin menambahkan data pembelian klik ikon
tambah data pembelian, yang terdapat pengisian data sebagai berikut</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0l-T7jG_2pgj6_4VOTXV38qsni9AYZRrDhwjLftW-BhYcxV9KcaD_k4Dk1wMfiWjYYSdXD9Oe2JtlbgjvuTa-6RWlvDUj-vvekfMatZ62vocLxryVa-EA_sNc6dqgs5TE3CXZA52KEfs/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0l-T7jG_2pgj6_4VOTXV38qsni9AYZRrDhwjLftW-BhYcxV9KcaD_k4Dk1wMfiWjYYSdXD9Oe2JtlbgjvuTa-6RWlvDUj-vvekfMatZ62vocLxryVa-EA_sNc6dqgs5TE3CXZA52KEfs/s1600/12.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> 13.</span><span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span><!--[endif]-->Jika ingin mengedit pada data pembelian klik
ikon edit yang akan menampilkan edit pada pembelian</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4djSNsGVqiFX1mLqsI4LzoZF95RNAsURZQIrE2Mxl_Sl8GCWKqk-8xPrEaqACdINf6__dMwdadrSaLvzTiD4lYrXe7dKbxsZvypVIv818FDVO_QMPX68x5b9vsX5xF-cwBwUowuYMLZA/s1600/13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4djSNsGVqiFX1mLqsI4LzoZF95RNAsURZQIrE2Mxl_Sl8GCWKqk-8xPrEaqACdINf6__dMwdadrSaLvzTiD4lYrXe7dKbxsZvypVIv818FDVO_QMPX68x5b9vsX5xF-cwBwUowuYMLZA/s1600/13.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
14.Jika ingin menghapus data pembelian klik ikon
hapus yang akan menampilkan pertanyaan apakah data akan dihapus</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2krLpxJjFaIXt6W9iBv8P_awRtgkrKsAjKLuVZYeYgopOC6BbopwmEEjFEHibRNCA6cM2BZKXJTrCcaYgb-hmV07R4tjA7ZrzRUeT8btQzgbV62gsPD9lstiZtx-ZmEOa6SqdgILJM48/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2krLpxJjFaIXt6W9iBv8P_awRtgkrKsAjKLuVZYeYgopOC6BbopwmEEjFEHibRNCA6cM2BZKXJTrCcaYgb-hmV07R4tjA7ZrzRUeT8btQzgbV62gsPD9lstiZtx-ZmEOa6SqdgILJM48/s1600/14.png" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
arsip kodingnya bisa di download disini <a href="http://bit.ly/2pUReZK" target="_blank">http://bit.ly/2pUReZK</a></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<br />
<div class="MsoListParagraphCxSpLast">
<br /></div>
Angga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-33218658773594369112017-05-01T21:40:00.000-07:002017-05-01T21:40:01.526-07:00MID SEMESTER1.create tabel penjualan<br />
create table penjualan(nonota varchar(10) primary key,<br />
kdbrg varchar(10),<br />
Tanggaltrans date ,<br />
Jumlahjual int,<br />
Hargajual int,<br />
Total int ,<br />
foreign key(kdbrg) references barang(kdbrg));<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggusixkHCuIomxreP75jSRtkLrtpqWhM0do0albFA6R_CjtMf9CkrZ0x5Jb85tAsQ700mpyIu2OEQsQqBPb0c_iPqRtPoOckcNr9Nc8xvQCpzNAhUyJGZbqhVND7sX3ZfbSAh6_skCDF0/s1600/1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggusixkHCuIomxreP75jSRtkLrtpqWhM0do0albFA6R_CjtMf9CkrZ0x5Jb85tAsQ700mpyIu2OEQsQqBPb0c_iPqRtPoOckcNr9Nc8xvQCpzNAhUyJGZbqhVND7sX3ZfbSAh6_skCDF0/s1600/1.PNG" /></a></div>
<br />
2.isi tabel penjualan<br />
insert into penjualan values<br />
('JUAL001','001','03/20/2017','10','3000','30000');<br />
insert into penjualan values<br />
('JUAL002','004','03/18/2017','15','4000','60000');<br />
insert into penjualan values<br />
('JUAL003','007','04/17/2017','30','5000','150000');<br />
insert into penjualan values<br />
('JUAL004','002','05/19/2017','25','6000','150000');<br />
insert into penjualan values<br />
('JUAL005','006','11/07/2017','20','2000','40000');<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhrmlOkSPupAK3o77fXYWs9zK9tNworiEIEefUdijEFyvLYecVDHejJ6QlNPi5vanXavN4XhJ0G2RExLeLdDQ4tI-2NSlnFJQLC4bvO6_pE5RjdKA3d_PmFDtN0sFfBZD_BnmUdODoBpQ/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhrmlOkSPupAK3o77fXYWs9zK9tNworiEIEefUdijEFyvLYecVDHejJ6QlNPi5vanXavN4XhJ0G2RExLeLdDQ4tI-2NSlnFJQLC4bvO6_pE5RjdKA3d_PmFDtN0sFfBZD_BnmUdODoBpQ/s1600/2.PNG" /></a></div>
<br />
3.tambah 1 fild<br />
alter table penjualan<br />
ADD sisa_stok int;<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitCzzaUdC-EL_bql2WMevf479oXwC_dhwCaZkMyCvEw9MQvsoU2NeC7TTkrZvlHQ8gETBJM2240Dvgi-_uJmvjqGa8fjrV3Jt6Uwax5JvQBkuV5kmaxGLy1ItKV2iANtRPhUpdCtYDETA/s1600/3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitCzzaUdC-EL_bql2WMevf479oXwC_dhwCaZkMyCvEw9MQvsoU2NeC7TTkrZvlHQ8gETBJM2240Dvgi-_uJmvjqGa8fjrV3Jt6Uwax5JvQBkuV5kmaxGLy1ItKV2iANtRPhUpdCtYDETA/s1600/3.PNG" /></a></div>
<br />
4.delet 1 record<br />
delete from penjualan<br />
where Hargajual='2000';<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-c44e3ZXVg-QU648VPS0fRzlXND-U-CDY5on0fWnB4jhzX5FeyRRKSudP3gvpAfEsPZd0okVYK3KamxxWJ_3csIjCHTCShk-2DHhaEIhcjxc-kiAGepK8GzIuX0LHYUtWMHoINox5uvI/s1600/4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-c44e3ZXVg-QU648VPS0fRzlXND-U-CDY5on0fWnB4jhzX5FeyRRKSudP3gvpAfEsPZd0okVYK3KamxxWJ_3csIjCHTCShk-2DHhaEIhcjxc-kiAGepK8GzIuX0LHYUtWMHoINox5uvI/s1600/4.PNG" /></a></div>
<br />
5.isi data field yang kosong<br />
update penjualan<br />
set sisa_stok='5'<br />
where nonota='JUAL001';<br />
update penjualan<br />
set sisa_stok='10'<br />
where nonota='JUAL002';<br />
update penjualan<br />
set sisa_stok='5'<br />
where nonota='JUAL003';<br />
update penjualan<br />
set sisa_stok='20'<br />
where nonota='JUAL004';<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbmXoGxiH892PhzJzD3aDRVDMwhYwaz4-RgrbilCV0Plt64g1fW0r4z4FQdMz8Qt339zfzUHg6Le-UZc7PVcpTarcn9pIcX-RvlJaj7PxZbckF7MyE1K3kHtvyj3Cs-Zs4Vm_sre1wlQQ/s1600/5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbmXoGxiH892PhzJzD3aDRVDMwhYwaz4-RgrbilCV0Plt64g1fW0r4z4FQdMz8Qt339zfzUHg6Le-UZc7PVcpTarcn9pIcX-RvlJaj7PxZbckF7MyE1K3kHtvyj3Cs-Zs4Vm_sre1wlQQ/s1600/5.PNG" /></a></div>
<br />
6.tampilkan nama barang dan tanggal jual<br />
select barang.nmbrg, penjualan.Tanggaltrans from penjualan<br />
inner join barang on penjualan.kdbrg=barang.kdbrg<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv2RRu-mCfHi1uSZVcf0SK8XzMZxhUIZo8zWhmDZDdTX7fGyJQK4mAxQNSGmWXpepbJDcf0mP9htOi8PrOFf7Ua0ScNsrvT0cIlSPkurMZzTrqim-4Vnr4S6HOsBLFFGso2lND-BAzPVM/s1600/6.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv2RRu-mCfHi1uSZVcf0SK8XzMZxhUIZo8zWhmDZDdTX7fGyJQK4mAxQNSGmWXpepbJDcf0mP9htOi8PrOFf7Ua0ScNsrvT0cIlSPkurMZzTrqim-4Vnr4S6HOsBLFFGso2lND-BAzPVM/s1600/6.PNG" /></a></div>
<br />
7.tampilkan jenis barang dan jumlah jual<br />
select barang.jnsbrg, penjualan.Jumlahjual from penjualan<br />
inner join barang on penjualan.kdbrg=barang.kdbrg<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTXurqfWuNYbO6E66Bv3LZnixld5xlzNl0p1dwvqFN80p0HwXaK4I06szWC6F7FQgGRiXEZoBeyVhrPhJVsuLOciyBMjauZn0wDyrFElGXqYOlEo-hk6dPD_pnn303nAf8UoeSGPFGnA0/s1600/7.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTXurqfWuNYbO6E66Bv3LZnixld5xlzNl0p1dwvqFN80p0HwXaK4I06szWC6F7FQgGRiXEZoBeyVhrPhJVsuLOciyBMjauZn0wDyrFElGXqYOlEo-hk6dPD_pnn303nAf8UoeSGPFGnA0/s1600/7.PNG" /></a></div>
<br />
8.tampilkan stok barang yang tanggal jualnya april 2017<br />
select barang.jumlah from penjualan<br />
inner join barang on penjualan.kdbrg=barang.kdbrg<br />
where MONTH(penjualan.Tanggaltrans)=04<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRkTNT-ZctQwOzVVPqG3myFGDXDwOjI0WDc4h3_4h30WYzCpQ63eYOX11uaQQsN-yK27sLmQYb4370XbEJQANi0i4QRH9JiPg5n08UM1NdEVX5snMNHAzwvOn4tSAimkP5DNgNFQGV5eM/s1600/8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRkTNT-ZctQwOzVVPqG3myFGDXDwOjI0WDc4h3_4h30WYzCpQ63eYOX11uaQQsN-yK27sLmQYb4370XbEJQANi0i4QRH9JiPg5n08UM1NdEVX5snMNHAzwvOn4tSAimkP5DNgNFQGV5eM/s1600/8.PNG" /></a></div>
<br />
9.tampilkan harga jual yang barangnya LA Light<br />
select penjualan.Hargajual from penjualan<br />
inner join barang on penjualan.kdbrg=barang.kdbrg<br />
where barang.nmbrg='La Light';<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr5sxpNvOHKTqkSDrZqOr9Ckp6hkoI1m6PNN3ED1MD3ItXPpG3YjOCfO5DaIYzyweezyDfaE1loCCXjZJViqlSC_mYYgG5yH6HozmxL8BO7UyAuD7PvPlJKrTyHg1BVz5vpqY_9eM8-hE/s1600/9.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr5sxpNvOHKTqkSDrZqOr9Ckp6hkoI1m6PNN3ED1MD3ItXPpG3YjOCfO5DaIYzyweezyDfaE1loCCXjZJViqlSC_mYYgG5yH6HozmxL8BO7UyAuD7PvPlJKrTyHg1BVz5vpqY_9eM8-hE/s1600/9.PNG" /></a></div>
<br />
10.tampilkan nama barang, tanggal beli, tanggal jual, stok<br />
select barang.nmbrg, pembelian.tanggalbeli, penjualan.Tanggaltrans, barang.jumlah<br />
from penjualan<br />
inner join barang on penjualan.kdbrg=barang.kdbrg<br />
inner join pembelian on barang.kdbrg=pembelian.kdbrg<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWCHwjqb_yd5cJIhb4SrVKt4nkcpGeJQpvtl9CMvTw7xiIRfKhyIz3t1HenZldF1b-qZ_tev4uy6-t7nXZxF75-ql48iLnj4E7pdl4d1vd3m30YUf_P0duM4s5mszdLHTqCraD47ssXoo/s1600/10.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWCHwjqb_yd5cJIhb4SrVKt4nkcpGeJQpvtl9CMvTw7xiIRfKhyIz3t1HenZldF1b-qZ_tev4uy6-t7nXZxF75-ql48iLnj4E7pdl4d1vd3m30YUf_P0duM4s5mszdLHTqCraD47ssXoo/s1600/10.PNG" /></a></div>
<br />
<br />Angga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-4372577277509519612017-04-17T22:13:00.002-07:002017-04-17T22:13:57.407-07:00menyambungkan tabel 1 dengan tabel lain menggunakan inner joinhai gaes kali ini saya akan memberikan tips cara menggunakan inner join untuk menyambungkan 2 tabel atau lebih<br />
<br />
<br />
1.Tampilkan nama supplier yang namanya indomie<br />
select nmsup from supplier<br />
inner join pembelian on supplier.kdsup=pembelian.kdsup<br />
inner join barang on pembelian.kdbrg=barang.kdbrg<br />
where barang.nmbrg='indomie'<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKxDUp-Hw_1Qf8uPHchR-kpE6bCL92R4GTiMUQl3WK4d4iqMsbPLBVaSyDZSDlVgdAZeOTtZD2LvBMyAtDcMot1Ap25y7xSPb7uoNcTTcH0NnycQzH11QUBNTlwdcNqMUuYLUhS2jPDto/s1600/1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKxDUp-Hw_1Qf8uPHchR-kpE6bCL92R4GTiMUQl3WK4d4iqMsbPLBVaSyDZSDlVgdAZeOTtZD2LvBMyAtDcMot1Ap25y7xSPb7uoNcTTcH0NnycQzH11QUBNTlwdcNqMUuYLUhS2jPDto/s1600/1.PNG" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
2.Tampilkan jumlah beli yang nama barang indomie<br />
select jumlahbeli from pembelian<br />
inner join barang on pembelian.kdbrg=barang.kdbrg<br />
where barang.nmbrg='indomie'<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoDisuKlSWTRcWrqoATF7gyFcyN_1ZXKe7Eo8cHJ0rioZHNs3ukhn1bYYyxiFIHDf2nxznpWDzGIi1pS3r3QNEUsvQTVsigs8SW9_ZxKmxqCDsKvpSKaCYMfY2EnSK1_SvY8psqrwDHQA/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoDisuKlSWTRcWrqoATF7gyFcyN_1ZXKe7Eo8cHJ0rioZHNs3ukhn1bYYyxiFIHDf2nxznpWDzGIi1pS3r3QNEUsvQTVsigs8SW9_ZxKmxqCDsKvpSKaCYMfY2EnSK1_SvY8psqrwDHQA/s1600/2.PNG" /></a></div>
<br />
<br />
3.tampilkan yang nama barang yang harga beli di atas 10.000(3000)<br />
select nmbrg from barang<br />
inner join pembelian on barang.kdbrg=pembelian.kdbrg<br />
where pembelian.hargabeli > 3000<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLZ-geN5I875MGk1JnTHFs43QkXjqfAJygzSHTcei7NL3Kvy-lYfpWZue6W0Qp6FT5TvcRCFiqZZSYyQ22FWw1aUHOwjur0nunu7oYjInc2b6WV8FgTr4kBSQymLnbfij-btlLEN-HdXo/s1600/3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLZ-geN5I875MGk1JnTHFs43QkXjqfAJygzSHTcei7NL3Kvy-lYfpWZue6W0Qp6FT5TvcRCFiqZZSYyQ22FWw1aUHOwjur0nunu7oYjInc2b6WV8FgTr4kBSQymLnbfij-btlLEN-HdXo/s1600/3.PNG" /></a></div>
<br />
<br />
4.tampilkan kode supplier ,nama suplier yang total pembelian diatas 100.000<br />
select supplier.kdsup,supplier.nmsup from supplier<br />
inner join pembelian on supplier.kdsup=pembelian.kdsup<br />
where pembelian.total > 100000<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoQKFyfqWjnGmfNZjNcbbpXmQARnOI6dXB769-djtkWrQAy_cdyvjQSuRXkTsrsWjXwNVriSerjdNtqlHcmXjj1CICVQYx2phWt7ZgMOlJPFsFFfgqG9SFRafsovX2vkRf2UwbnGBpTfI/s1600/4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoQKFyfqWjnGmfNZjNcbbpXmQARnOI6dXB769-djtkWrQAy_cdyvjQSuRXkTsrsWjXwNVriSerjdNtqlHcmXjj1CICVQYx2phWt7ZgMOlJPFsFFfgqG9SFRafsovX2vkRf2UwbnGBpTfI/s1600/4.PNG" /></a></div>
<br />
<br />
5.tampilkan jenis barang yang stocknya habis<br />
select jnsbrg from barang<br />
inner join pembelian on barang.kdbrg=pembelian.kdbrg<br />
where barang.jumlah - pembelian.jumlahbeli <=0<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9cwiijNjvyQ2mbAW5h0aRxaIi6j0BDdEJkTVXMlcNLivVz-EBpE-yzBxv55xtFT2kP1BjwcwaO6g5EZMtkItxmiO2NCNAzJBncDKCGWd29PqlsfNGj5eldw0osNQ5tqclQMUwHUu3z4I/s1600/5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9cwiijNjvyQ2mbAW5h0aRxaIi6j0BDdEJkTVXMlcNLivVz-EBpE-yzBxv55xtFT2kP1BjwcwaO6g5EZMtkItxmiO2NCNAzJBncDKCGWd29PqlsfNGj5eldw0osNQ5tqclQMUwHUu3z4I/s1600/5.PNG" /></a></div>
<br />
<br />
6. tampilkan nama supplier yang melaksanakan transaksi tanggal 1 Januari 2017<br />
select nmsup from supplier<br />
inner join pembelian on supplier.kdsup=pembelian.kdsup<br />
where pembelian.tanggalbeli='2017-01-01'<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaEEedVN0myMb8-b3OdnFtLhwU6izm687AZRddQlMWHNsTzEaLlMCdInlTxyUVX0W55IOTC6su6-rfxU5kAIA9Tod8Z6k_ICzeouzJZLmG2RaffVURQCg3rarySCnjlw801Hr6DXIul4A/s1600/6.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaEEedVN0myMb8-b3OdnFtLhwU6izm687AZRddQlMWHNsTzEaLlMCdInlTxyUVX0W55IOTC6su6-rfxU5kAIA9Tod8Z6k_ICzeouzJZLmG2RaffVURQCg3rarySCnjlw801Hr6DXIul4A/s1600/6.PNG" /></a></div>
<br />
<br />
7. tampilkan nama barang, nama supplier untuk bulan 1 agustus 2017<br />
select barang.nmbrg, supplier.nmsup from pembelian<br />
inner join supplier on supplier.kdsup=pembelian.kdsup<br />
inner join barang on pembelian.kdbrg=barang.kdbrg<br />
where MONTH(pembelian.tanggalbeli)=8<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfteqathC928Iyv5DpU0_ufOglTOf2zD6MF77goqfvy7RRP26O98vflDlxc6kS6fhWfdxe3dqxxJ-f63ue91AOg45w1RRDHb-CuEQqhj2G51KwEuLDoOrNN6VT3ut1d3bcxV6GKNaafyI/s1600/7.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfteqathC928Iyv5DpU0_ufOglTOf2zD6MF77goqfvy7RRP26O98vflDlxc6kS6fhWfdxe3dqxxJ-f63ue91AOg45w1RRDHb-CuEQqhj2G51KwEuLDoOrNN6VT3ut1d3bcxV6GKNaafyI/s1600/7.PNG" /></a></div>
<br />
<br />
8.tampilkan no nota ,nama barang, nama supplier dan alamat perusahaan supplier<br />
select pembelian.nonota, barang.nmbrg,supplier.nmsup, supplier.Alamatkantor from pembelian<br />
inner join barang on barang.kdbrg=pembelian.kdbrg<br />
inner join supplier on pembelian.kdsup=supplier.kdsup<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOxjPeCEOcg0CmYDKmgUGZCHdgTHVCchcakt2HpdmJgaYAAS-TPRQqEOpe4Vj79_9C1Fq5sflBSb04c_5PDWjxaVWQQNfgyR-MFTJtsNc20BYzmlYXux8QGKMneOgB5wVZgR7WSEzgeeU/s1600/8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOxjPeCEOcg0CmYDKmgUGZCHdgTHVCchcakt2HpdmJgaYAAS-TPRQqEOpe4Vj79_9C1Fq5sflBSb04c_5PDWjxaVWQQNfgyR-MFTJtsNc20BYzmlYXux8QGKMneOgB5wVZgR7WSEzgeeU/s1600/8.PNG" /></a></div>
<br />
<br />
9.tampilkan nama barang dan nama supplier untuk barang yang stoknya dibawah 100<br />
select barang.nmbrg, supplier.nmsup from barang<br />
inner join pembelian on barang.kdbrg=pembelian.kdbrg<br />
inner join supplier on pembelian.kdsup=supplier.kdsup<br />
where barang.jumlah <100<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL3wmsz_Wrq0ehj8tZh9AGt4_kSg9RJ23X5QqwjqHXtWehwBrA9xNRGIk2wqzbVjI-wdjJKiIy3ura9PyfH_lGIaWvuw8VAz9ZiQTisIXqeM_LGl-wboIGt83fpINftgkEcklI6UL69qU/s1600/9.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL3wmsz_Wrq0ehj8tZh9AGt4_kSg9RJ23X5QqwjqHXtWehwBrA9xNRGIk2wqzbVjI-wdjJKiIy3ura9PyfH_lGIaWvuw8VAz9ZiQTisIXqeM_LGl-wboIGt83fpINftgkEcklI6UL69qU/s1600/9.PNG" /></a></div>
<br />
<br />
10.tampilkan semua nama barang dan nama supplier<br />
select barang.nmbrg, supplier.nmsup from barang<br />
inner join pembelian on barang.kdbrg=pembelian.kdbrg<br />
inner join supplier on pembelian.kdsup=supplier.kdsup<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhek0EJo6VtJ-ANdd0_YNwwlJ91OPl1yHOLIEQfeeXz4hwlIEPLrS0K5KoWCKBDvQxTTHz8IYztwKgxgmRoxzYOCniohKa058NhsbFMiTrKMdPPufbXpFQzrg45_HGGuMNcIwyKZvZrlus/s1600/10.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhek0EJo6VtJ-ANdd0_YNwwlJ91OPl1yHOLIEQfeeXz4hwlIEPLrS0K5KoWCKBDvQxTTHz8IYztwKgxgmRoxzYOCniohKa058NhsbFMiTrKMdPPufbXpFQzrg45_HGGuMNcIwyKZvZrlus/s1600/10.PNG" /></a></div>
<br />
<br />
<br />
sekian tipsnya kali ini jumpa lagi di artikel saya yang akan datangAngga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-63130887632464322682017-04-06T13:59:00.005-07:002017-04-06T13:59:49.246-07:00TUGAS SQL join 10 soal 1. Tampilkan Nomor Nota, Nama Barang, Nama Supplier dan Jumlah Beli yang Nama Suppliernya 'Angga'<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGRZQvt41P0dMREWXZKj9LP7ZLZF1CGvJKPfKAsVtA-QYJ58LONpIs_QhqvEKD_GD_T9ZZX8YX9jSA1T1Mua5joEdiYRwnKYFppBoAJVdJWmku3CdR_1GhYX25VfymghyjSi8EwIKXBHs/s1600/1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGRZQvt41P0dMREWXZKj9LP7ZLZF1CGvJKPfKAsVtA-QYJ58LONpIs_QhqvEKD_GD_T9ZZX8YX9jSA1T1Mua5joEdiYRwnKYFppBoAJVdJWmku3CdR_1GhYX25VfymghyjSi8EwIKXBHs/s1600/1.PNG" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
2.Tampilkan Tanggal Beli, Nama Supplier, Alamat Kantor dan Alamat Kantornya Jl. Gondang Manis</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAf1CvrCKMIGKUFer_HX9fVnm3Wf4feqVO_OTlT68ZIUyxzivxmekHHNbJcs80IX5Y-VvjzM9mhl4S35jSMNNWfkgNKMYtztlVskpW08GfrRzdsVsm5sGmUgai_zTz1Dq5xw9hlfoqGRc/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAf1CvrCKMIGKUFer_HX9fVnm3Wf4feqVO_OTlT68ZIUyxzivxmekHHNbJcs80IX5Y-VvjzM9mhl4S35jSMNNWfkgNKMYtztlVskpW08GfrRzdsVsm5sGmUgai_zTz1Dq5xw9hlfoqGRc/s1600/2.PNG" /></a></div>
<div>
<br /></div>
<div>
3. Tampilkan Nomor Nota, Nama Barang, Nama Supplier dan Jumlah Beli yang Jumlah Belinya 300</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZw8s2tRniuhyphenhyphenDeKRQQ3HZk5BTl-no-XJjUMpD4kaDr89Q0egF4dnBnDaO1iTsz6NmnjpD2mFy5vmZEns128YWm_v5RHt9U9a9FcbK_0OrH8qoc-zLeQfCZXjcKZMnq0jwwmo64Fx4rrw/s1600/3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZw8s2tRniuhyphenhyphenDeKRQQ3HZk5BTl-no-XJjUMpD4kaDr89Q0egF4dnBnDaO1iTsz6NmnjpD2mFy5vmZEns128YWm_v5RHt9U9a9FcbK_0OrH8qoc-zLeQfCZXjcKZMnq0jwwmo64Fx4rrw/s1600/3.PNG" /></a></div>
<div>
<br /></div>
<div>
4. Tampilkan Nama Barang, Nama Supplier yang Jumlah Belinya antara 150-200</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvktCR3YFQHPqGw4IX9UMt9YZYoRWYsnkWvcX7f0bAapYkQRRDMR-KPRKtyjcXN2Wd9NSgcCOVPd_6c_TW6B5EgNeD-JcAIQu6R2PRhsZ6xwrTNoxeCIbzt_R1cohi6qu2mC7Asj6wOzc/s1600/4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvktCR3YFQHPqGw4IX9UMt9YZYoRWYsnkWvcX7f0bAapYkQRRDMR-KPRKtyjcXN2Wd9NSgcCOVPd_6c_TW6B5EgNeD-JcAIQu6R2PRhsZ6xwrTNoxeCIbzt_R1cohi6qu2mC7Asj6wOzc/s320/4.PNG" width="320" /></a></div>
<div>
<br /></div>
<div>
5. Tampilkan Nomor Nota, Kode Barang, Nama Barang, Jenis Barang dan Tanggal Beli yang nomor notanya 'HG009'</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-HeHJDbt3Csi6u9rtUkNhI7svgkCL8AnVPiGuT7ESuzEhpQ5sQqcJRzu21WLhsD3mqf2rzMmq0Rce9FzajHYiC1CIdUSCo18SlwZBoC-eEtyz2ulEnep29GcqrdU7rWFB6CcdxSOQSFU/s1600/5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="77" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-HeHJDbt3Csi6u9rtUkNhI7svgkCL8AnVPiGuT7ESuzEhpQ5sQqcJRzu21WLhsD3mqf2rzMmq0Rce9FzajHYiC1CIdUSCo18SlwZBoC-eEtyz2ulEnep29GcqrdU7rWFB6CcdxSOQSFU/s320/5.PNG" width="320" /></a></div>
<div>
<br /></div>
<div>
6. Tampilkan Nomor Nota, Nama Supplier, Tanggal Lahir dan Harga Beli yang Harga Beli nya 2000</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2jolK5anMx1Tchjai2e1v-OSXpmM86UK8YJa85cPpj4hHrfOB2Lr_BrZ2myhzN0UN5vpyKzZc9ZkMvr0Yff4UKlWnzKoZ5tiUXmt_bvZcQWCcydjVNH4RDxbvv0QEyLR5swT6NbM4lnM/s1600/6.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2jolK5anMx1Tchjai2e1v-OSXpmM86UK8YJa85cPpj4hHrfOB2Lr_BrZ2myhzN0UN5vpyKzZc9ZkMvr0Yff4UKlWnzKoZ5tiUXmt_bvZcQWCcydjVNH4RDxbvv0QEyLR5swT6NbM4lnM/s320/6.PNG" width="320" /></a></div>
<div>
<br /></div>
<div>
7. Tampilkan Jenis Barang, Jumlah Beli, dan Nama Supplier</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3HP2pP7PEZnZIHoHIoEyXKz2vua5sAZuBLnPeXtwLhgQrZRQvHorXmuajKOFY1VKsFEwvs_EgLfqbB9J96wxvxvnv5q5JXGjMMiFlFcaAYU2KP3Tw74pzMEDZgVH9BpFWZYFEPaBxeeI/s1600/7.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="191" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3HP2pP7PEZnZIHoHIoEyXKz2vua5sAZuBLnPeXtwLhgQrZRQvHorXmuajKOFY1VKsFEwvs_EgLfqbB9J96wxvxvnv5q5JXGjMMiFlFcaAYU2KP3Tw74pzMEDZgVH9BpFWZYFEPaBxeeI/s320/7.PNG" width="320" /></a></div>
<div>
<br /></div>
<div>
8. Tampilkan Nama Barang, Jenis Barang dari nama Supplier Khoirir</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha2F0s2l0EYOkuuYrBcQic-M4fQ69MnaWg7tXub-XVrGvy6lvG0FLVdWM_UG9_Va5VNjbaNY6G71TLATJeKVNMEz4hCwv7wZI5W74MH-IBJsJWAoh1MSrOPBM2xTtD5dj_oKlIn5Mr88U/s1600/8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha2F0s2l0EYOkuuYrBcQic-M4fQ69MnaWg7tXub-XVrGvy6lvG0FLVdWM_UG9_Va5VNjbaNY6G71TLATJeKVNMEz4hCwv7wZI5W74MH-IBJsJWAoh1MSrOPBM2xTtD5dj_oKlIn5Mr88U/s320/8.PNG" width="320" /></a></div>
<div>
<br /></div>
<div>
9. Tampilkan Jenis Barang, Tanggal Beli dan Total yang Totalnya kurang dari 100000</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYclbcbcjU6NMtlvo_sU5bF9KjSAX1nftV1nhnBsskV3_stvVFdP3PeTCqYIJzWKvkpoCF7GSCiJ19CY18xE1nU7hs087_1we6EyBEmU5UZfqiP2F0RQZpnxOKwKXZc4OVYV4bXOUjVg0/s1600/9.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYclbcbcjU6NMtlvo_sU5bF9KjSAX1nftV1nhnBsskV3_stvVFdP3PeTCqYIJzWKvkpoCF7GSCiJ19CY18xE1nU7hs087_1we6EyBEmU5UZfqiP2F0RQZpnxOKwKXZc4OVYV4bXOUjVg0/s1600/9.PNG" /></a></div>
<div>
<br /></div>
<div>
10. Tampilkan Nomor Nota, Kode Barang, Nama Barang, Jenis Barang dan Tanggal Beli yang Jenis Barangnya shampo</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkS4uzgE_E4daf-ub1vPju7NSRkprScaZezDAcFP961LYGfZm3Is4l9L4r74eCGAtpmTJ387gaeCxApg_FrGbkbj5WJXjXxpYuhopQspQfUip4NsjeRqV7TY8ACdFHySJUwIGLwaywVCw/s1600/10.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkS4uzgE_E4daf-ub1vPju7NSRkprScaZezDAcFP961LYGfZm3Is4l9L4r74eCGAtpmTJ387gaeCxApg_FrGbkbj5WJXjXxpYuhopQspQfUip4NsjeRqV7TY8ACdFHySJUwIGLwaywVCw/s1600/10.PNG" /></a></div>
<div>
<br /></div>
Angga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-91524078600221229372017-04-03T21:22:00.004-07:002017-04-03T21:22:48.578-07:00MENAMBAHKAN TABEL DAN MENGISINYAhai gaes kita ketemu lagi saya akan melanjutkan yang kemarin ,kini saya akan menambahkan tabelnya lagi<br />
<br />
<br />
saya akan menambahkan tabel pembelian dengan cara gini<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLaM0IIzVEQmDk7-w_HUBIfwACuL_a_VpMq7xTIf8OIbCI1UiX3wbIS8T3g_4b1M0PfTa-VFuaLmQnukeGT04QZDJe7ZB-WFVfwaIXyxmVzFlYw9Wcs7V43hc17YZSxnfsFQVfmvWoW34/s1600/pembelian.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLaM0IIzVEQmDk7-w_HUBIfwACuL_a_VpMq7xTIf8OIbCI1UiX3wbIS8T3g_4b1M0PfTa-VFuaLmQnukeGT04QZDJe7ZB-WFVfwaIXyxmVzFlYw9Wcs7V43hc17YZSxnfsFQVfmvWoW34/s640/pembelian.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
dan saya akan mengisi tabel pembelian </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKLFti-zig4CWH-sWmix4Yvjeecik87Kcbh7FD9XDULkZFKkDK7-n_zGBkO8Std8hXQoJclGv_Nj-AA6_9KiTfPR2ff9DP40EDvIrM-63rs1GAodeFlyWpvSqP83qEg6FbQdgXxGWIvRI/s1600/select+pembelian.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="322" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKLFti-zig4CWH-sWmix4Yvjeecik87Kcbh7FD9XDULkZFKkDK7-n_zGBkO8Std8hXQoJclGv_Nj-AA6_9KiTfPR2ff9DP40EDvIrM-63rs1GAodeFlyWpvSqP83qEg6FbQdgXxGWIvRI/s640/select+pembelian.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
sekian dulu pertemuan kali ini jumpa lagi minggu depanAngga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-81474099019200652042017-03-20T22:34:00.000-07:002017-03-20T22:34:17.195-07:00PRAKTEK HARI KE-3Hai gaes saya akan membahas kelanjutan praktek SQL di blog saya yang sebelumnya<br />
<br />
<ol>
<li>mengedit tabel barang ,menambahkan 1 field tanggal kadaluarsa<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAZZazqG7V2l2QJygFyw7C1UqwWJhic6krQl8iKY-Jr9IX3RzEKLQRvdOPp6UkyfexG_DU9GF4SndjtrEzZdv-fQ0wQE2lByrDiUS_trPTSqwM3OUXUhzUknP3InSV7_K8cVHnW6AVPrs/s1600/11.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAZZazqG7V2l2QJygFyw7C1UqwWJhic6krQl8iKY-Jr9IX3RzEKLQRvdOPp6UkyfexG_DU9GF4SndjtrEzZdv-fQ0wQE2lByrDiUS_trPTSqwM3OUXUhzUknP3InSV7_K8cVHnW6AVPrs/s320/11.PNG" width="320" /></a></li>
<li>isi tanggal kadaluarsa<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio9Kw-f4nknLOCWrZ49gbHHlNdPhDC06gOK9r8gUwmlSg7nYChaHPUnRr1qaQ2_zibNPjRQpMVktRGmhjTarDc4eBtFDcP_gHz91CUUtjBqkzqLC_tQx5YA1W1J9g2QR9qiJMgWeBDk4M/s1600/12.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio9Kw-f4nknLOCWrZ49gbHHlNdPhDC06gOK9r8gUwmlSg7nYChaHPUnRr1qaQ2_zibNPjRQpMVktRGmhjTarDc4eBtFDcP_gHz91CUUtjBqkzqLC_tQx5YA1W1J9g2QR9qiJMgWeBDk4M/s320/12.PNG" width="245" /></a></li>
<li>tampilkan tanggal kadaluarsa<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0cUj3aXYrt_l0ER83-RSghCc8Sm_g_5Hg5uPKC7Hf5ewtsiFetzw886h-QJ680RU0pQ90m-YgBvMP09y1RYY9WJqCRdR1si6f5yynSLk4vrN5dtack-Y0VA-SRz29LL271Vi2j9GovM4/s1600/13.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0cUj3aXYrt_l0ER83-RSghCc8Sm_g_5Hg5uPKC7Hf5ewtsiFetzw886h-QJ680RU0pQ90m-YgBvMP09y1RYY9WJqCRdR1si6f5yynSLk4vrN5dtack-Y0VA-SRz29LL271Vi2j9GovM4/s1600/13.PNG" /></a></li>
<li>hapus tanggal kadaluarsa yang tahun 2016<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp4u-AlxKJQDv0u7ilxJ6iQdLCYHPMTp-3sGEMDz6St7oMtTn_dPfwt4TlDzy8yKuqzY23lCOArV9hOQBL2jjR8cBwrVxUUpyUJgDGJdsYOT9AazA4u6kGcThQXPQ7NUWYPlpUBnQg8H4/s1600/14.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="145" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp4u-AlxKJQDv0u7ilxJ6iQdLCYHPMTp-3sGEMDz6St7oMtTn_dPfwt4TlDzy8yKuqzY23lCOArV9hOQBL2jjR8cBwrVxUUpyUJgDGJdsYOT9AazA4u6kGcThQXPQ7NUWYPlpUBnQg8H4/s320/14.PNG" width="320" /></a></li>
<li>rubah tanggal kadaluarsa bulan desember ,menjadi bulan november<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisAHvKjZulzFZiOkKTETyTMPkWrPYBB75Z0Ftnxy4tLT6EnME49dlUXUurMQIs7CnlXlA0pq0BEw-QOzP7PNUFz2zLgRBSqR3YI-6mTmDgjzlRBLNYIw5yJ7TtLy0xSmlxNyAYS6M1QTw/s1600/15.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="157" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisAHvKjZulzFZiOkKTETyTMPkWrPYBB75Z0Ftnxy4tLT6EnME49dlUXUurMQIs7CnlXlA0pq0BEw-QOzP7PNUFz2zLgRBSqR3YI-6mTmDgjzlRBLNYIw5yJ7TtLy0xSmlxNyAYS6M1QTw/s320/15.PNG" width="320" /></a></li>
<li>edit tabel supplier ,tambahkan 1 fild jenis produk<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaedWf7z3tgR_vL7XxWaUqT5nZ54kKy80c0DnFcLqrwbxtFgcO16JksAjAfWqCdsbhCXJoTNExQUV57FTrc2yX4FtdI23zwHDr_kTgxwcDGOHgVxYJUguwAJcv9MTzopX6yrc0BE8ZWoE/s1600/16.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaedWf7z3tgR_vL7XxWaUqT5nZ54kKy80c0DnFcLqrwbxtFgcO16JksAjAfWqCdsbhCXJoTNExQUV57FTrc2yX4FtdI23zwHDr_kTgxwcDGOHgVxYJUguwAJcv9MTzopX6yrc0BE8ZWoE/s320/16.PNG" width="320" /></a></li>
<li>isi jenis produk<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr4UnnWKanHIpqyUN8WbVdTdtVtPVukla8p_tgv9f8jiwKFKLsuq6DEX2IX3BLcJ6jn0yNjOD6PznO80H8uZLjcWIF4cWJ7-RBQxkvNK-1hsv4OWkf8rMxdz-cjp6lqlefLovWpGM6j94/s1600/17.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr4UnnWKanHIpqyUN8WbVdTdtVtPVukla8p_tgv9f8jiwKFKLsuq6DEX2IX3BLcJ6jn0yNjOD6PznO80H8uZLjcWIF4cWJ7-RBQxkvNK-1hsv4OWkf8rMxdz-cjp6lqlefLovWpGM6j94/s320/17.PNG" width="320" /></a></li>
<li>tampilkan jenis produk dalam supplier<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC9nIbLW3dulXcFNv9HS60iueOXlzdk-sSsvpedOAz-1QykDRA0dWpyOvIuSWMwYi5VPJEPIcj26eatZXXkO-UbcInZ6E5Dy0-mZiCrfSP7hZlhAv6T0X5r3KrhLhGyma-dLanuRzDupM/s1600/18.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="316" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC9nIbLW3dulXcFNv9HS60iueOXlzdk-sSsvpedOAz-1QykDRA0dWpyOvIuSWMwYi5VPJEPIcj26eatZXXkO-UbcInZ6E5Dy0-mZiCrfSP7hZlhAv6T0X5r3KrhLhGyma-dLanuRzDupM/s320/18.PNG" width="320" /></a></li>
<li>hapus jenis produk sikat gigi dalam supplier<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0Eyeh-QaT20V5NIozr_fkZMgDjj8ewXPEX52CiDD00w6OrRxP_lpCX8KnpXVGVpR0aCMdu8x39YVa56HiQXHM9DCaCYPFeH1Z5w9521htI56fjzHKhHsSLRzbIWzLZTFIFoymlY5xJZE/s1600/19.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="120" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0Eyeh-QaT20V5NIozr_fkZMgDjj8ewXPEX52CiDD00w6OrRxP_lpCX8KnpXVGVpR0aCMdu8x39YVa56HiQXHM9DCaCYPFeH1Z5w9521htI56fjzHKhHsSLRzbIWzLZTFIFoymlY5xJZE/s320/19.PNG" width="320" /></a></li>
<li>ubah jenis produk sabun mandi , menjadi sabun cuci<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfGZRNJZ6jfX0pfbsxsbpwAbXDM57IZ7bXzvsIw4BgaXHTulA0AEFufakNncNx5Xotnyysu4LRH_2OVRejgZUJKJc4I17oRdeWrJ_xoXc25KNTD-pwWdFkXsbtFOV2fMUKMF83bon-DIQ/s1600/20.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfGZRNJZ6jfX0pfbsxsbpwAbXDM57IZ7bXzvsIw4BgaXHTulA0AEFufakNncNx5Xotnyysu4LRH_2OVRejgZUJKJc4I17oRdeWrJ_xoXc25KNTD-pwWdFkXsbtFOV2fMUKMF83bon-DIQ/s320/20.PNG" width="320" /></a></li>
</ol>
Angga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-76453210554555791292017-03-09T18:21:00.000-08:002017-03-09T18:21:01.317-08:00Tutorial membuat dan mengisi databasehai gaessss<br />Kali ini saya akan membagikan tutorial pembuatan tabel pada database. Namun sebelum membuat tabel dan mengisikannya, kita harus membuat databasenya terlebih dahulu dengan cara seperti di bawah ini:<br /><br />create database "201553078"<br /><br />kemudian kita gunakan database yang telah kita buat itu dengan cara :<br /><br />use "201553078"<br /><br />baru setelah itu kita baru bisa membuat tabelnya. kita akan membuat tabel dengan nama supplier.<br /><br />create table supplier(<br />kdsup varchar(10) primary key,<br />nmsup varchar(30),<br />tglhr date,<br />Alamatkantor varchar(40),<br />telpkantor varchar(15),<br />jekel varchar(15),<br />email varchar(30)<br />)<br /><br />seletah di execute, untuk melihat tabel tersebut kita bisa gunakan perintah select yaitu:<br /><br />select * from supplier<br /><br />Sekarang kita bisa mengisi tabel tersebut dengan data-data sebagai berikut:<br /><br />insert into supplier<br />values<br />('sup001','Firman Ilahudin','12/04/1980','Jl. Gondang Manis','0291-5546738','Pria','Firman001@gmail.com'),<br />('sup002','Joko Waluyo','07/03/1979','Jl. Bumi Wonosari','024-889772','Pria','Jwal@gmail.com'),<br />('sup003','ilham wahid','19/08/1982','Jl.Dersalam','0291-889324','Pria','Wahid@gmail.com'),<br />('Sup004','angga','08/05/1996','Jl. Menara raya','0291-880599','pria','Angga@gmail.com'),<br />('Sup005','Khoirir','03/12/1990','Jl. singgo Candi','0291-973456','pria','Khoirir@gmail.com'),<br />('Sup006','Riza','07/09/1980','Jl. Gondang Manis','0271-889324','pria','Riza@gmail.com'),<br />('Sup007','Era','07/02/1989','Jl. KHR Asnawi','0231-687654','pria','Era009@gmail.com'),<br />('Sup008','Kiki','09/10/1995','Jl. Muria Raya','0251-213680','pria','Kiki@gmail.com'),<br />('Sup009','Fatma','26/12/1989','Jl. Bumi Wonosari','0291-895678','Wanita','Fatma@gmail.com'),<br />('Sup010','sintia','29/01/1988','Jl. Dersalam','0291-876645','wanita','Sintia@gmail.com')<br /><br />untuk menampilkan data yang telah di inputkan kita gunakan perintah select lagi, yaitu :<br /><br />select *from supplier<br /><br />Tampilkan Data Supplier yang kantornya daerah Dersalam<br /><br />select *from supplier where Alamatkantor='Jl. Dersalam'<br /><br />Tampilkan Data Email Supplier yang rumahnya daerah gondangmanis<br /><br />select email from supplier where Alamatkantor='Jl. gondang manis'<br /><br />Tampilkan Data Supplier yang rumahnya daerah KHR Asnawi<br /><br />select *from supplier where Alamatkantor='Jl.KHR Asnawi'<br /><br />Tampilkan Data Supplier yang lahir pada tahun 1988<br /><br />select *from supplier where tglhr='%1988%'<br /><br />Tampilkan Data Supplier yang berjenis Kelamin wanita<br /><br />select *from supplier where jekel='Wanita'<br /><br />Tampilkan Data Supplier yang rumahnya daerah Bumi Wonosari<br /><br />select *from supplier where Alamatkantor='Jl. Bumi Wonosari'<br /><br />Tampilkan Data Supplier yang berjenis kelamin pria<br /><br />select *from supplier where jekel='Pria'<br /><br />Tampilkan Data Supplier Namanya ara<br /><br />select *from supplier where nmsup='Ara'<br /><br />Tampilkan Email Supplier yang rumahnya daerah Muria Raya<br /><br />select email from supplier where Alamatkantor='Jl. Muria Raya'<br /><br />Tampilkan Data Supplier yang rumahnya daerah Singo Candi<br /><br />select *from supplier where Alamatkantor='Jl. Singo Candi'Angga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0tag:blogger.com,1999:blog-8499365186463586284.post-336495549137866822017-02-27T21:32:00.001-08:002017-02-27T21:32:23.798-08:00hasil kuliah hari ini 1<div class="MsoNormal">
<span lang="IN">create database "201553078"<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">use "201553078"<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">create table barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">(kdbrg varchar(10) primary key,<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">nmbrg varchar(50),<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">jnsbrg varchar(20),<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">harga int,<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">jumlah int<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">)<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">insert into barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">values ('001', 'indomie', 'mie instan',2000,
50)<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">insert into barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">values ('002', 'sunsilk', 'shampo',14000,
100),<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">('003', 'pepsoden', 'pasta gigi',7000, 75),<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">('004', 'La Light', 'rokok',18000, 200),<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">('005', 'SGM 3', 'Susu Bayi',75000, 150)<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">Select * from barang<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0WLydTXMs4xYv8-AtGTgc4zJXaJ6BOUluto399cx28FqqU8Xb9h_M6mxSPB7uyr9SKd_N9d6jZ1UxUEaPKgDzu0IJov0G-M_Of9z6v-HM0RZECUbZNeEfmWBFjNExo6vD3nFjaReRYUs/s1600/select+barang..PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0WLydTXMs4xYv8-AtGTgc4zJXaJ6BOUluto399cx28FqqU8Xb9h_M6mxSPB7uyr9SKd_N9d6jZ1UxUEaPKgDzu0IJov0G-M_Of9z6v-HM0RZECUbZNeEfmWBFjNExo6vD3nFjaReRYUs/s1600/select+barang..PNG" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">1.tampilkan nama indomie<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where nmbrg='indomie'<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvdfFneQFgOSIrm02QpECb63iJ_ld0abHNHKvDtuhW2S6zCqKrH1kgwSWBN1W0U8GytZ6r79kkAu8ceEAoCPis8DNxj-gt-2_Fmu44qkK-7YtsY0lgJjBt7TekHxSfSyqrbhTKksyGKQo/s1600/soal+1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvdfFneQFgOSIrm02QpECb63iJ_ld0abHNHKvDtuhW2S6zCqKrH1kgwSWBN1W0U8GytZ6r79kkAu8ceEAoCPis8DNxj-gt-2_Fmu44qkK-7YtsY0lgJjBt7TekHxSfSyqrbhTKksyGKQo/s1600/soal+1.PNG" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">2.tampilkan jenis barang shampo<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where jnsbrg='shampo'<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjr8X_0mLNYSNek3LjRoqZR-jKo0HBOrykZquzvO-UbZOoXlOQ7hPNh1DebVHDlIhFHdKEjv3OodNu_Lu2RqAHSt69UkUtU3mjnMWIVJpxNJht2_nSiWGh1Fq2HIvksBflXO01iPwpyqrI/s1600/soal+2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjr8X_0mLNYSNek3LjRoqZR-jKo0HBOrykZquzvO-UbZOoXlOQ7hPNh1DebVHDlIhFHdKEjv3OodNu_Lu2RqAHSt69UkUtU3mjnMWIVJpxNJht2_nSiWGh1Fq2HIvksBflXO01iPwpyqrI/s1600/soal+2.PNG" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">3.tampilkan harga barang 18000<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where harga=18000<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdlEb1jKvn5dpLSt980pX4l9MKKOxhEcLS3jaT-hWe3uPWGgMBDEbrOtul3ChyphenhyphenTd_1HbuQwlOtq78y4fFTNCGeQqk7P11dFhsYZVmzW1pXl-CkvxsQYpWEWZCwaI1IJQ0p399_ZvvglEs/s1600/soal+3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdlEb1jKvn5dpLSt980pX4l9MKKOxhEcLS3jaT-hWe3uPWGgMBDEbrOtul3ChyphenhyphenTd_1HbuQwlOtq78y4fFTNCGeQqk7P11dFhsYZVmzW1pXl-CkvxsQYpWEWZCwaI1IJQ0p399_ZvvglEs/s1600/soal+3.PNG" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">4.tampilkan jumlah 150<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where jumlah=150<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjk3eVU-uNLodFODHRc-JuFuP0dbcYcs4LEDYRqpvPuALaq80_5aSDpOcP_AW6k4SBJsS0aYzKNOAZn876RR0PMtEDxcKAvfNKeVxp7jVEtP_0eXkGKspeb8KUh_-rMNDpJ0EkWVIqEhM/s1600/soal++4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjk3eVU-uNLodFODHRc-JuFuP0dbcYcs4LEDYRqpvPuALaq80_5aSDpOcP_AW6k4SBJsS0aYzKNOAZn876RR0PMtEDxcKAvfNKeVxp7jVEtP_0eXkGKspeb8KUh_-rMNDpJ0EkWVIqEhM/s1600/soal++4.PNG" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">5.tampilkan jenis barang susu bayi<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where jnsbrg='susu bayi'<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhP7XOG4Z6PKk9vsB4AoTABZVL7HfoCqKSrthdIq7S_Pvc0vYSk03AuAl_OElyfIPy78YjuPSWZhSXzz2AdbuFpVxxioiQT_IPB_i11_nBFMJzMmK-xlMzigpqL7_9X441qFINr99ubUs0/s1600/soal++5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhP7XOG4Z6PKk9vsB4AoTABZVL7HfoCqKSrthdIq7S_Pvc0vYSk03AuAl_OElyfIPy78YjuPSWZhSXzz2AdbuFpVxxioiQT_IPB_i11_nBFMJzMmK-xlMzigpqL7_9X441qFINr99ubUs0/s320/soal++5.PNG" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">6.tampilkan nama barang 'sunsilk' dan nama
barang pepsoden<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where nmbrg='sunsilk' or nmbrg='pepsoden'<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjlFo-UYRr1ematEh8K2wzXKuI_tTv8zwfCWBzCh6WUIE3DUazEUhH9xQ_a_SXLS4YHbbIAXyUdfMyXNWrPuKc05ShD4ngfUb5xu-DxOOBQZc7G_gZJ2GdRcKky7ZiL_-v0Xz8UX0hTzQ/s1600/soal+6.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjlFo-UYRr1ematEh8K2wzXKuI_tTv8zwfCWBzCh6WUIE3DUazEUhH9xQ_a_SXLS4YHbbIAXyUdfMyXNWrPuKc05ShD4ngfUb5xu-DxOOBQZc7G_gZJ2GdRcKky7ZiL_-v0Xz8UX0hTzQ/s320/soal+6.PNG" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">7.tampilkan nama barang la light dan sgm 3<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where nmbrg='la light' or nmbrg='sgm 3'<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNNBcZtRABIh23S5CAAZIqeu7-_CICUrTHcUhFPJsBR1GZxPf9p0-bqoL9e-zel4eX9W_PcroGjxWPKCvIz7oOnyMxHG46GqhTuB7oRSLIid8y0VAwUejfUcu0F1EN58Wyj4MoEFsg7Js/s1600/soal+7.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNNBcZtRABIh23S5CAAZIqeu7-_CICUrTHcUhFPJsBR1GZxPf9p0-bqoL9e-zel4eX9W_PcroGjxWPKCvIz7oOnyMxHG46GqhTuB7oRSLIid8y0VAwUejfUcu0F1EN58Wyj4MoEFsg7Js/s1600/soal+7.PNG" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">8.tampilkan yang harganya 2000 & 75000<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where harga=2000 or harga=75000<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQB6WPB4RgP0Sun4Is_uWsJWWuiE518ctmumsBGKg3q1tlvYut1lqRloSQAP46_puGdmkSSbe1E8MDDoPBs_lO0qCV62fAG4Oi3GC61nDQ-7FNP0HGow4Ti4ieQgWOqRvrjkS3E0xG2zw/s1600/soal+8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="228" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQB6WPB4RgP0Sun4Is_uWsJWWuiE518ctmumsBGKg3q1tlvYut1lqRloSQAP46_puGdmkSSbe1E8MDDoPBs_lO0qCV62fAG4Oi3GC61nDQ-7FNP0HGow4Ti4ieQgWOqRvrjkS3E0xG2zw/s320/soal+8.PNG" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">9.tampilkan yang jumlahnya 100 atau 200<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where jumlah=100 or jumlah=200<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdd5KSuVuzIAAff3OazrnpyZAvzB0nJ2bdeKll3krXYf0yDFSGE-sZlCK98l-Oqn_kNR90VBuTb7DIUIwF9QMUno3ma65aS2KUceuV9YH2gSduPICwSTZzN6WyhBoFZSqX5ZS2H0dBu3c/s1600/soal+9.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdd5KSuVuzIAAff3OazrnpyZAvzB0nJ2bdeKll3krXYf0yDFSGE-sZlCK98l-Oqn_kNR90VBuTb7DIUIwF9QMUno3ma65aS2KUceuV9YH2gSduPICwSTZzN6WyhBoFZSqX5ZS2H0dBu3c/s1600/soal+9.PNG" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">10.tampilkan yang namanya indomie dan
jumlahnya 75<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">select * from barang<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">where nmbrg='indomie' and jumlah=7<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="IN">pakai and<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2Q0WPzTiYDbV-fDKFsKpv3vLhrGn_UqmU2uU_60jRayFw7haStBj2EGDb4HqfUOrFxmna19g9LNIULrZCU_a_qiRvhEIdqSoci9U83QkpF4goGjehtRNBWQIr2_e4MMKNENslIaRbLE0/s1600/soal+10.1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2Q0WPzTiYDbV-fDKFsKpv3vLhrGn_UqmU2uU_60jRayFw7haStBj2EGDb4HqfUOrFxmna19g9LNIULrZCU_a_qiRvhEIdqSoci9U83QkpF4goGjehtRNBWQIr2_e4MMKNENslIaRbLE0/s320/soal+10.1.PNG" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="IN">Pakai or <o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdceVucnPlaVAtRTmFV4_l1vxqKMHHyToyt55X56hQxP5QDu_0-1rHpLS3Ia2_IR6Iw_rueLywQefoldHcMSQlHZvPAEPcFDKbgBxq7f8ThLyS6CFklEBMJ7mGGFlqPzL8JXM9UeRRG58/s1600/soal+10.2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdceVucnPlaVAtRTmFV4_l1vxqKMHHyToyt55X56hQxP5QDu_0-1rHpLS3Ia2_IR6Iw_rueLywQefoldHcMSQlHZvPAEPcFDKbgBxq7f8ThLyS6CFklEBMJ7mGGFlqPzL8JXM9UeRRG58/s320/soal+10.2.PNG" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
Angga25http://www.blogger.com/profile/09179435659333774682noreply@blogger.com0