Tutorial Koding: SQL Server

Showing posts with label SQL Server. Show all posts

Penggunaan Fungsi LEFT MID RIGHT di SQL

Karena sudah lumayan semenjak postingan saya terkhir tentang SQL <a href="http://dwirandyherdinanto.blogspot.com/2014/02/penggunaan-sum-min-max-count-avg-di-sql.html">Penggunaan SUM MIN MAX COUNT AVG di SQL</a>, pada malam hari ini saya kan membahas tentang <a href="http://adf.ly/pnvai">Menggunakan Fungis Left Mid Right di SQL</a>,<br />
saya akan membahas ketiga fungsi tersebut<br />
<br />
Contohnya kita mempunyai data sebagai berikut<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA9jPQ8hTij91BKu4e2kB9V-2et_5hvBO2QzsYfO7Kk-HhbneAeYKxruJ-y8cVlpx7V4Zq_4zOECNHWWIX_MVIeH737pXGPFQ9pDGX1fAszHmtykNO3Ivvlxn4A0fZ9zHgNekOLHLtytSH/s1600/Screenshot_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Penggunaan Fungsi LEFT MID RIGHT di SQL" border="0" height="80" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA9jPQ8hTij91BKu4e2kB9V-2et_5hvBO2QzsYfO7Kk-HhbneAeYKxruJ-y8cVlpx7V4Zq_4zOECNHWWIX_MVIeH737pXGPFQ9pDGX1fAszHmtykNO3Ivvlxn4A0fZ9zHgNekOLHLtytSH/s1600/Screenshot_1.png" title="Penggunaan Fungsi LEFT MID RIGHT di SQL" width="320" /></a></div>
<br />
<b>LEFT()</b><br />
Fungsi ini digunakan untuk mengambil karekter pada sebuah string dengan panjang tertentu yang di mulai dari kiri.<br />
<br />
Misalkan kita ingin menampilkan nis dari 3 karakter paling kiri<br />
<br />
<pre class="brush:html">select LEFT(nis,3) as nis,nama,alamat,kelamin,website from siswa</pre>
<pre class="brush:html"></pre>
<br />
Maka data yang akan tampil ada seperti gambar dibawah ini<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTGlBDhp28Ec3mCdxOyAlUnUksMgSEn80hPTBvUAOWgu9BeUbTCfDH__EC2W4msfAqb66cSSbPyQXnt1uhCsEo1aeAuXC3j2OSWdpTXX3qKqDMl630i9L8cSdW0ys_FS0lTA8rhe_DztvU/s1600/Screenshot_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Penggunaan Fungsi LEFT MID RIGHT di SQL" border="0" height="82" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTGlBDhp28Ec3mCdxOyAlUnUksMgSEn80hPTBvUAOWgu9BeUbTCfDH__EC2W4msfAqb66cSSbPyQXnt1uhCsEo1aeAuXC3j2OSWdpTXX3qKqDMl630i9L8cSdW0ys_FS0lTA8rhe_DztvU/s1600/Screenshot_3.png" title="Penggunaan Fungsi LEFT MID RIGHT di SQL" width="320" /></a></div>
<br />
<b>MID()</b><br />
Fungsi ini digunakan untuk mengambil karakter pada sebuah string dimulai dari tengah<br />
<br />
Misalkan kita ingin menampilkan nis dari karakter ke 4 sebanyak 3 karakter<br />
<br />
SQL Server<br />
<pre class="brush:html">select SUBSTRING(nis,4,3) as nis,nama,alamat,kelamin,website from siswa</pre>
MySQL<br />
<pre class="brush:html">select MID(nis,4,3) as nis,nama,alamat,kelamin,website from siswa</pre>
<blockquote class="tr_bq">
karena di SQL Server tidak ada Fungsi MID maka kita bisa juga menggunakan Fungsi SUBSTRING sebagai pengganti MID</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGlIcFpHwz3dQjokksc44iqpk_uW9isuxREnQliEEh5gKYslFTgOvtP5cvEZGsNLPgKI27dZFMrnbGAax6pSgsB4Cqf79yZNPpVHOrV5u5D44BBzve6vrtCrN9S-LCvBTmf9WQOYJxmTSk/s1600/Screenshot_4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Penggunaan Fungsi LEFT MID RIGHT di SQL" border="0" height="82" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGlIcFpHwz3dQjokksc44iqpk_uW9isuxREnQliEEh5gKYslFTgOvtP5cvEZGsNLPgKI27dZFMrnbGAax6pSgsB4Cqf79yZNPpVHOrV5u5D44BBzve6vrtCrN9S-LCvBTmf9WQOYJxmTSk/s1600/Screenshot_4.png" title="Penggunaan Fungsi LEFT MID RIGHT di SQL" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<b>RIGHT()</b></div>
<div class="separator" style="clear: both; text-align: left;">
Fungsi RIGHT hampir sama dengan fungsi left, fungsi ini mengambil karekter pada sebuah string dengan panjang tertentu yang di mulai dari kanan</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Misalkan kita ingin menampilkan nis dari 2 karakter paling kanan</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<pre class="brush:html">select RIGHT(nis23) as nis,nama,alamat,kelamin,website from siswa</pre>
<br />
Maka data yang akan tampil ada seperti gambar dibawah ini<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibMg23LZGZBMtXTcDFLa6joLc2VhmhztUX11U51wrL-iZUa79d8gNamTFbfdCivII-4n2qMiAzgza5ozPVnZccZNXzK7fis_7f4RBz3MOoT_AFppWBpyZYOiZTzLnF4V1BPpJDkIUvC72v/s1600/Screenshot_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Penggunaan Fungsi LEFT MID RIGHT di SQL" border="0" height="82" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibMg23LZGZBMtXTcDFLa6joLc2VhmhztUX11U51wrL-iZUa79d8gNamTFbfdCivII-4n2qMiAzgza5ozPVnZccZNXzK7fis_7f4RBz3MOoT_AFppWBpyZYOiZTzLnF4V1BPpJDkIUvC72v/s1600/Screenshot_5.png" title="Penggunaan Fungsi LEFT MID RIGHT di SQL" width="320" /></a></div>
<br />
<br />
Sekian dari saya.<br />
Terima kasih atas kunjugannya semoga bermanfaat

Penggunaan Fungsi LEFT MID RIGHT di SQL

Karena sudah lumayan semenjak postingan saya terkhir tentang SQL Penggunaan SUM MIN MAX COUNT AVG di SQL , pada malam hari ini saya kan memb...

Monday, June 23, 2014

Penggunaan SUM, MIN, MAX, COUNT, AVG Di SQL

Pada postingan kali ini saya akan membahas tentang <a href="http://adf.ly/d5I1I" target="_blank">Penggunaan SUM, MIN, MAX, COUNT, AVG Di SQL</a><br />
<div>
baiklah sebelum memulainya ada baiknya anda membaca postingan saya sebelumnya yaitu <a href="http://adf.ly/cvcGa" target="_blank">Syntak Dasar SQL</a></div>
<div>
<br /></div>
<div>
Apa itu <b>SUM</b> ?</div>
<div>
SUM adalah suatu fungsi pada SQL yang digunakan untuk menjumlahkan nilai dari sekumpulan record</div>
<div>
<br /></div>
<div>
Apa itu MIN ?</div>
<div>
MIN adalah suatu fungsi pada SQL yang digunakan untuk mendapatkan nilai terkecil dari sekumpulan record</div>
<div>
<br /></div>
<div>
Apa itu MAX?</div>
<div>
MAX adalah kebalikan dari SUM, yaitu fungsi yang digunakan untuk mendapatkan nilai tertinggi dari sekumpulan record</div>
<div>
<br /></div>
<div>
Apa itu COUNT?</div>
<div>
Count adalah suatu fungsi pada SQL yang digunakan untuk mendapatkan jumlah baris atau record dari suatu tabel</div>
<div>
<br /></div>
<div>
Untuk contoh penggunaannya :</div>
<div>
1. Buatlah sebuah database dengan nama latsql</div>
<div>
<br /></div>
<div>
2. Buatlah sebuah tabel di dalam database latsql dengan script dibawah ini<br />
<br /></div>
<div>
<pre class="brush:html">CREATE TABLE barang (
kd_brg varchar(20) primary key,
nm_brg varchar(50) not null,
hrg_jual int not null,
stock int not null
)</pre>
</div>
<div>
<br />
3. Isi data pada tabel barang dengan script dibawah ini<br />
<br />
<pre clas="brush:html">INSERT INTO barang (kd_brg,nm_brg,hrg_jual,stock) 
values 
('BRG0001','Kecap','8000','10'),
('BRG0002','Sabun','5000','15'),
('BRG0003','Kapas','3000','5'),
('BRG0004','Sambal','7000','15'),
('BRG0005','Aqua','3000','15')</pre>
<br />
Jika sudah sekarang waktunya untuk <a href="http://adf.ly/d5I1I" target="_blank">Penggunaan SUM, MIN, MAX, COUNT, AVG Di SQL</a><br />
<br />
Contoh penggunaan SUM, misalkan anda ingin menjumlahkan stock semua data barang<br />
<br />
<pre class="brush:html">SELECT SUM(stock) as jumlahstock FROM barang</pre>
<blockquote class="tr_bq">
as jumlahstcok adalah fungsi untuk memberikan nama field pada query tersebut</blockquote>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVqkZ2UNKBJ4qwgd6zkLoFCsujBhc9m3OQ_LodMcGx3YRdKrolHPlyfeNp5H7_ky18qCVqWwbbiyE_oSu0c8REcAiaLL0qbFL_3BLjCoyFRWLUhH5HKSVtSMC-BdX0MPBppkEjd9NOh_qa/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="185" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVqkZ2UNKBJ4qwgd6zkLoFCsujBhc9m3OQ_LodMcGx3YRdKrolHPlyfeNp5H7_ky18qCVqWwbbiyE_oSu0c8REcAiaLL0qbFL_3BLjCoyFRWLUhH5HKSVtSMC-BdX0MPBppkEjd9NOh_qa/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_1.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Contoh penggunaan MIN, misalkan anda ingin mendapatkan nilai terkecil dari stock barang</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<pre class="brush:html">SELECT MIN(stock) as stockterkecil FROM barang</pre>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<blockquote class="tr_bq">
as stockterkecil adalah fungsi untuk memberikan nama field pada query tersebut</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzuGZjwMuPRR-9RwUrPR-_k_40CcEu5QzubtRAur9G4XTCM1cz9cSAvJfgobmpSEn4ERWbe9bOywWYh1wXNBvfwkBFjDeHTCYIdRiaquPr8gPKpNzYN8nPlHl5t1sg5YT-MsNwcrnzRAi6/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzuGZjwMuPRR-9RwUrPR-_k_40CcEu5QzubtRAur9G4XTCM1cz9cSAvJfgobmpSEn4ERWbe9bOywWYh1wXNBvfwkBFjDeHTCYIdRiaquPr8gPKpNzYN8nPlHl5t1sg5YT-MsNwcrnzRAi6/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_3.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Contoh penggunaan MAX, misalkan anda ingin mendapatkan nilai terbesar dari stock barang</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<pre class="brush:html">SELECT MAX(stock) as stockterbesar FROM barang</pre>
<blockquote class="tr_bq">
as stockterbesar adalah fungsi yang memberikan nama field pada query tersebut</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBk6KZNYP2q223RbxL8wb1lRnxP6Um3bUJy9Bnl3TAd0V8LdYXmdN3cB7AjcXaoTSth4Z08xdOixVbXaRbgo-1h3LhNeHg9Ok74J-ufpnBwu0rLhiwrw1faMMIYy9EifoYrkiHgM9Dy-IW/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBk6KZNYP2q223RbxL8wb1lRnxP6Um3bUJy9Bnl3TAd0V8LdYXmdN3cB7AjcXaoTSth4Z08xdOixVbXaRbgo-1h3LhNeHg9Ok74J-ufpnBwu0rLhiwrw1faMMIYy9EifoYrkiHgM9Dy-IW/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_2.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Contoh penggunaan COUNT, misalkan anda ingin mendapatkan jumlah barang yang memiliki stock 15</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<pre class="brush:html">SELECT count(stock) as stock15 FROM barang where stock='15'</pre>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<blockquote class="tr_bq">
as stock15 adalah fungsi yang memberikan nama field pada query tersebut</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-oBxiCNej4gwQ3_B0JxbrXTzDOyUH7BeI8CjaqkCqm8C0Pc3tO7ZHBaqmFBabr-LjLoFnYi4fcg4MsGQDqrJ3dIlpeWZsbgXwd-mFRLAb4XhaXVCXZT52AWX4UUMkq0RJ_NAaiW2zoUAY/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-oBxiCNej4gwQ3_B0JxbrXTzDOyUH7BeI8CjaqkCqm8C0Pc3tO7ZHBaqmFBabr-LjLoFnYi4fcg4MsGQDqrJ3dIlpeWZsbgXwd-mFRLAb4XhaXVCXZT52AWX4UUMkq0RJ_NAaiW2zoUAY/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_4.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Contoh penggunaan AVG, misalkan anda ingin mendapatkan rata-rata harga jual barang</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<pre class="brush:html">SELECT AVG(stock) as ratastock from barang</pre>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<blockquote class="tr_bq">
as ratastock adalah fungsi yang memberikan nama field pada query tersebut</blockquote>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEDTWu-W1IUCjAHb32LrRt5lqm1n8EwRZXtO3_36PMSgtgb1Tkv4g1I7p6wZDThKugikSQL4lpcEZz2BBiXXOgpWGGam9_3hdcb_l5-RcjqgmvDc5kur9xr96JIDos5M1zDeNWYYug9xb9/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEDTWu-W1IUCjAHb32LrRt5lqm1n8EwRZXtO3_36PMSgtgb1Tkv4g1I7p6wZDThKugikSQL4lpcEZz2BBiXXOgpWGGam9_3hdcb_l5-RcjqgmvDc5kur9xr96JIDos5M1zDeNWYYug9xb9/s1600/Penggunaan_SUM,MIN,MAX,COUNT,AVG_Di_SQl_5.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Anda bisa mendownload database + source codenya di <a href="http://adf.ly/d5VsA" rel="nofollow" target="_blank">sinii</a></div>
<div class="separator" style="clear: both; text-align: center;">
password : http://dwirandyherdinanto.blogspot.com/</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Sekian dulu dari saya</div>
<div class="separator" style="clear: both; text-align: left;">
Terima kasih sudah mengunjungi blog saya,,dan jangan lupa berikan komentar untuk artikel ini</div>
</div>

Penggunaan SUM, MIN, MAX, COUNT, AVG Di SQL

Pada postingan kali ini saya akan membahas tentang Penggunaan SUM, MIN, MAX, COUNT, AVG Di SQL baiklah sebelum memulainya ada baiknya and...

Wednesday, February 05, 2014

Penggunaan Limit Di SQL Server

Malam semua kali ini saya akan memposting tentang <a href="http://dwirandyherdinanto.blogspot.com/2014/01/penggunaan-limit-di-sql-server.html">Penggunaan Limit DI SQL Server</a><br />
sebelumnya ada baiknya untuk membaca postingan saya sebelumnya yaitu <a href="http://dwirandyherdinanto.blogspot.com/2013/10/syntak-dasar-sql-server.html">Syntak Dasar SQL Server</a><br />
<br />
Apa itu Limit?<br />
Mungkin jika kalian pernah membuat web dengan menggunakan database <b>MySQL</b> kalian sering menggunakan limit untuk melakukan Paging Data<br />
Limit digunakan untuk menampilkan record sesuai dengan jumlah limit yang kalian inginkan<br />
<br />
Oke langsung saja<br />
<br />
1. Pertama-tama buka dulu SQL Server Mangement Studio<br />
2. Buatlah sebuah database dengan nama <b>Latihan</b><br />
3. Buat table dengan syntak seperti dibawah ini<br />
<br />
<pre class="brush:html">Create Table anggota (
id_agt varchar(10) primary key,
nm_agt varchar(30),
kelamin varchar(15),
alamat varchar(50)
)</pre>
<br />
4. Tambahkan data pada table <b>anggota</b> dengan syntak seperti dibawah ini<br />
<br />
<pre class="brush:html">insert into anggota 
(id_agt,nm_agt,kelamin,alamat)
values
('AGT0001','DWI RANDY HERDINANTO','LAKI - LAKI','BANDAR LAMPUNG'),
('AGT0002','DWIKI YOGISTIAWAN','LAKI - LAKI','BANDAR LAMPUNG'),
('AGT0003','FEBRIAN KURNIA','PEREMPUAN','BANDAR LAMPUNG'),
('AGT0004','HASANI','LAKI - LAKI','BANDAR LAMPUNG'),
('AGT0005','IIN INDAWATI','PEREMPUAN','BANDAR LAMPUNG')
</pre>
<br />
5. Misalkan kita ingin menapilkan data dengan <b>Limit 0,3</b><br />
<br />
<pre class="brush:html">select top 3 id_agt,nm_agt,kelamin,alamat 
from anggota
where id_agt not in(select top 0 id_agt from anggota)
</pre>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
maka akan tampil data seperti gambar dibawah ini<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvzoVmMLOAFn658aBWAAufUNPHBmHGm8812PnLjlZzE2JqLofzPjE8t_Zqhyyv23nptESIJmoAB_xQZOgQXQdOKITTT0fjPLxRTZmXjwOe4fVOLoqKr2ZfvCz6Ss8p8N-REU1f5y1zSNMS/s1600/Penggunaan_Limit_Di_SQL_Server_01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Penggunaan Limit Di SQL Server" border="0" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvzoVmMLOAFn658aBWAAufUNPHBmHGm8812PnLjlZzE2JqLofzPjE8t_Zqhyyv23nptESIJmoAB_xQZOgQXQdOKITTT0fjPLxRTZmXjwOe4fVOLoqKr2ZfvCz6Ss8p8N-REU1f5y1zSNMS/s1600/Penggunaan_Limit_Di_SQL_Server_01.png" title="Penggunaan Limit Di SQL Server" width="320" /></a></div>
<br />
Atau misalkan kita ingin menampilkan data dengan<b> Limit 2,5</b><br />
<br />
<pre class="bursh:html">select top 5 id_agt,nm_agt,kelamin,alamat
from anggota </pre>
<pre class="bursh:html">where id_agt not in(select top 2 id_agt from anggota)
</pre>
<br />
maka akan tampil data seperti gambar dibawah ini<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrUV15ZhumYu145JHda3yLZGe2nbWybDig2HoU71mpnjnSLCtYkB-cvpAx0KOw8knTUNqQWWC7LlFuFtJIFCCbrDsilzZRQApJQRWXM3mKnJhaptbmprNqWg2mjjcxZ2Jqt8f6pJdw5GCv/s1600/Penggunaan_Limit_Di_SQL_Server_02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Penggunaan Limit Di SQL Server" border="0" height="144" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrUV15ZhumYu145JHda3yLZGe2nbWybDig2HoU71mpnjnSLCtYkB-cvpAx0KOw8knTUNqQWWC7LlFuFtJIFCCbrDsilzZRQApJQRWXM3mKnJhaptbmprNqWg2mjjcxZ2Jqt8f6pJdw5GCv/s1600/Penggunaan_Limit_Di_SQL_Server_02.png" title="Penggunaan Limit Di SQL Server" width="320" /></a></div>
<br />
Semoga berhasil =))<br />
<br />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Source Sans Pro'; font-size: 16px; line-height: 25px; margin: 0px; padding: 0px;">
<span style="margin: 0px; padding: 0px; text-align: justify;">Sekian dulu dari saya</span></div>
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Source Sans Pro'; font-size: 16px; line-height: 25px; margin: 0px; padding: 0px;">
Jangan lupa Follow,Comment dan berikan G+1 untuk kelancaran blog ini :)</div>
<span style="margin: 0px; padding: 0px; text-align: justify;">Semoga artikel ini bermanfaat untuk kalian,  terima kasih sudah mengunjungi blog saya :) </span>

Penggunaan Limit Di SQL Server

Malam semua kali ini saya akan memposting tentang Penggunaan Limit DI SQL Server sebelumnya ada baiknya untuk membaca postingan saya sebelu...

Tuesday, January 21, 2014

Attach Database SQL Server

Malam semua kali ini saya akan memposting tentang Cara Attach Database SQL Server<br />
<br />
Oke langsung saja yang perlu di persiapkan adalah<br />
1. File .mdf  dan .ldf<br />
2. SQL Server jika menggunakan SQL Server Express harap instal SQL Management Studio terlebih dahulu<br />
<br />
Langkah pertama adalah<br />
1. Buka SQL Server Management Studio<br />
2. Pilh Server, masukan username dan password lalu klik connect <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSfJfuRprSkyDxasZn7I_8ZCcAsC8lRkaH18COIT7y7HSw1ro8wYPkgVriEzIr1JfxP3zljy1FIQZrwQx7qUCF10PoMwNkUBJMuAiSPtG57EhILWJALywi0uqIDEKeaz8ltUxQictzQdNz/s1600/Sql_server_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Cara Attach Database SQL Server" border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSfJfuRprSkyDxasZn7I_8ZCcAsC8lRkaH18COIT7y7HSw1ro8wYPkgVriEzIr1JfxP3zljy1FIQZrwQx7qUCF10PoMwNkUBJMuAiSPtG57EhILWJALywi0uqIDEKeaz8ltUxQictzQdNz/s320/Sql_server_1.png" title="Cara Attach Database SQL Server" width="320" /></a></div>
3. Klik kanan database yang ada di sebelahkanan<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIeVlJ8aZo2GlIKzauLxwD_dZb6xD8sx-iKGtMLVv898Ql9RD-AbX00r5ArGUsg0BXcwXm7sC_Y8boIYo1pSmaJ6WwRZ1q7dGJjeH8jpdSKPY-GuORiTc1RJ3uKqqK4M-S01AMEoLNC8D0/s1600/sql_server2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Cara Attach Database SQL Server" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIeVlJ8aZo2GlIKzauLxwD_dZb6xD8sx-iKGtMLVv898Ql9RD-AbX00r5ArGUsg0BXcwXm7sC_Y8boIYo1pSmaJ6WwRZ1q7dGJjeH8jpdSKPY-GuORiTc1RJ3uKqqK4M-S01AMEoLNC8D0/s1600/sql_server2.png" title="Cara Attach Database SQL Server" /></a></div>
<br />
 4. Maka akan muncul tampilan seperti di bawah ini, lalu klik add dan cari file .mdf yang kamu punya lalu klik OK<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1Kn2EzpzTEPfxCZhD1fjQQwA_l1StX1wzxvfCGzL32S2GEWv9y1jWx-R9S3FDyOJF6Bp_FFTkUBbstwPHcrOufNyD0dlH1wJHzjHBVaVGGWKKFFV4RUXRNNeuQ4Bx6C0xV3JvNQ3VbjYN/s1600/Sql_server3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Cara Attach Database SQL Server" border="0" height="288" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1Kn2EzpzTEPfxCZhD1fjQQwA_l1StX1wzxvfCGzL32S2GEWv9y1jWx-R9S3FDyOJF6Bp_FFTkUBbstwPHcrOufNyD0dlH1wJHzjHBVaVGGWKKFFV4RUXRNNeuQ4Bx6C0xV3JvNQ3VbjYN/s320/Sql_server3.png" title="Cara Attach Database SQL Server" width="320" /></a></div>
5. Dan langkah terakhir anda tinggal klik ok, lalu tunggu lah sejenak sampai proses selesai<br />
<br />
<br />
Semoga berhasil<br />
Sekian dulu dari saya<br />
semoga artikel ini bermanfaat untuk anda, terima kasih sudah mengunjungi blog saya :)

Attach Database SQL Server

Malam semua kali ini saya akan memposting tentang Cara Attach Database SQL Server Oke langsung saja yang perlu di persiapkan adalah 1. Fi...

Wednesday, December 11, 2013

Membuat login aman dari SQL Injection

Malem semua kali ini saya akan memposting tentang membuat login aman dari SQL Injection,<br />
ya walaupun ini cara lama,mungkin ada yang belum tau :D<br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">Secara singkat <b>SQL injection</b> adalah menambahkan perintah SQL Query melalui dengan tujuan untuk memodifikasi sql query yang sudah ada atau menciptakan SQL Query baru.</span><br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">Sebagai contoh :</span><br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">saya mempunyai SQL Query untuk login program yang saya buat dengan VB.NET seperti ini</span><br />
<blockquote class="tr_bq">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">select username,password from admin where username=' " & txt_username.text & " ' and password=' " & txt_password.text & " '</span></span> </blockquote>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">tapi jika pengguna program menginputkan username 'OR '1'='1 dan password 'OR '1'='1 lalu </span></span><br />
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;"><br /></span></span></div>
<div style="text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMP64NU4_DVkcHkB9cOaA368TZayO0TQyRfEE9es-UEdV2bbPSyVEW66gbsnntAkuwnDCfpj0VNBpaAz5Cnv_A5WQbdB00r08yM4bl2bEoR2IFRiAwzpkRkVUpgUWPlZoLZYclNfheS2VC/s1600/Screenshot_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMP64NU4_DVkcHkB9cOaA368TZayO0TQyRfEE9es-UEdV2bbPSyVEW66gbsnntAkuwnDCfpj0VNBpaAz5Cnv_A5WQbdB00r08yM4bl2bEoR2IFRiAwzpkRkVUpgUWPlZoLZYclNfheS2VC/s320/Screenshot_2.png" width="320" /></a></div>
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">setelah program di jalankan maka SQL Query kita akan menjadi seperti ini :</span></span></div>
<blockquote class="tr_bq">
<span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">select username,password from admin where username=' ' or '1'='1' and password=' ' or '1'='1'</span></span> </blockquote>
maka ini akan menghasilkan nilai TRUE, sehingga user (anonymous) berhasil login ke aplikasi yang kita buat tanpa perlu mengetahui username atau password yang sebenarnya<br />
<br />
Tapi, ada beberapa cara yang dapat digunakan untuk mengatasi agar hal itu tidak terjadi<br />
<br />
1. Menghilangkan karakter kutip 1 (') sebagai contoh replace(txt_username.text," ' ","")<br />
sebagai contoh :<br />
<blockquote class="tr_bq">
select username,password from admin where username=' " & Replace(txt_username.Text, " ' ", "") & " ' and password=' " & replace(txt_password.Text," ' ","") & " '</blockquote>
2. Membatasi MaxLength Textbox sesuai dengan Lenght Field yang ada di database dengan itu maka user tidak bisa mengisi Textbox secara bebas<br />
<br />
cara diatas adalah beberapa cara yang dapat digunakan dari sekumpulan cara yang dapat digunakan untuk membuat login aman dari SQL Injection<br />
<br />
cara diatas juga berlaku untuk bahasa pemrograman lain seperti PHP,C#,VB.NET dan lain - lain<br />
kita hanya perlu menerapkan logika yang sama dengan bahasa pemrograman yang kita gunakan<br />
sekian postingan saya malam ini semoga dapat menambah wawasan kita semua

Membuat login aman dari SQL Injection

Malem semua kali ini saya akan memposting tentang membuat login aman dari SQL Injection, ya walaupun ini cara lama,mungkin ada yang belum t...

Thursday, October 24, 2013

Mengatasi error "String or binary data would be truncated. The statement has been terminated."

<span style="font-family: Courier New, Courier, monospace;">Malam semua setelah beberapa jam yang lalu saya memposting tentang <a href="http://dwirandyherdinanto.blogspot.com/2013/10/crud-dengan-vbnet-bagian-1.html" target="_blank">CRUD dengan VB.NET Bagian 1</a> kali ini saya akan memposting </span><br />
<span style="font-family: Courier New, Courier, monospace;">C<b>ara mengatasi error "String or binary data would be truncated.</b></span><br />
<pre class="brush: sql; title: ; notranslate" title=""><b><span style="font-family: Courier New, Courier, monospace;">The statement has been terminated."</span></b></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">yah beberapa waktu yang lalu saya pernah mengalami mengalami error tersebut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">saya sempat bingung juga kenapa bisa terjadi error tersebut,padalah script untuk insert data nya sudah benar</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">lalu setelah searching di google saya menemukan solusinya</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">ternyata error itu disebabkan karena kita menginputkan data yang karakternya melebihi dari Lenght column yang kita buat</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">sebagai contoh saya membuat table sebagai berikut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">create table customer (</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">kd_customer varchar(5) not null primary key,</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">nama varchar(30) not null,</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">alamat varchar(30) not null)</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">lalu saya insert data dengan script sebagai berikut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">insert into customer (kd_customer,nama,alamat) values ('CUS123','Dwi Randy Herdinanto','Bandar Jaya')</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">maka ketika dijalankan akan muncul error seperti gambar di bawah ini</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii6zFJ7SsnTJfNyBPDeaeqKoIq1DhIaIcpKnmezgE3aHe4XSP65DWkH_uyrqRHcUfktSbiaDGxgjZQJwpEy2FuShuf7H39dVlRThF6gB6c96P_pwzP68zLoM1e6QI8YFZ8V3EcKNjRp-Of/s1600/Screenshot_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii6zFJ7SsnTJfNyBPDeaeqKoIq1DhIaIcpKnmezgE3aHe4XSP65DWkH_uyrqRHcUfktSbiaDGxgjZQJwpEy2FuShuf7H39dVlRThF6gB6c96P_pwzP68zLoM1e6QI8YFZ8V3EcKNjRp-Of/s320/Screenshot_3.png" width="320" /></a></div>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">kenapa terjadi error seperti gambar itu?</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">itu terjadi karena saya mengisi kd_customer dengan cus123 yang panjang kakternya 6, sedangkan pada column kd_customer Lenght nya hanya 5,</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">namun jika kita insert dengan script sebagai berikut</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">insert into customer (kd_customer,nama,alamat) values ('CUS12','Dwi Randy Herdinanto','Bandar Jaya')</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">maka ketika dijalankan akan akan berhasil disimpan seperti gambar di bawah ini</span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyvqoev2vJcb5KkUfa1kkfKHzIB0UTi7YQR895YpxqID-qRGrifCPSG_TikSYZmarRXTDlLk1T3uYpi0IMvMFg3nwSHA83wRU-vOP08N6F0W5qz71BQcVFct9SNp8lkO2uUIwJB4dsm2KA/s1600/Screenshot3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyvqoev2vJcb5KkUfa1kkfKHzIB0UTi7YQR895YpxqID-qRGrifCPSG_TikSYZmarRXTDlLk1T3uYpi0IMvMFg3nwSHA83wRU-vOP08N6F0W5qz71BQcVFct9SNp8lkO2uUIwJB4dsm2KA/s320/Screenshot3.png" width="320" /></a></div>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">
</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">yah sekian postingan saya kali ini</span></pre>
<pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">semoga bermanfaat bagi yang membaca :D</span></pre>

Mengatasi error "String or binary data would be truncated. The statement has been terminated."

Malam semua setelah beberapa jam yang lalu saya memposting tentang CRUD dengan VB.NET Bagian 1 kali ini saya akan memposting C ara mengat...

Tuesday, October 22, 2013

Syntak Dasar SQL

<div class="" style="clear: both; text-align: left;">
<span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;">Malam semua <a href="http://dwirandyherdinanto.blogspot.com/2013/10/cara-menginstal-sql-server-2008_12.html" target="_blank"> </a>kali ini saya akan posting tentang <span style="color: blue;"><a href="http://dwirandyherdinanto.blogspot.com/2013/10/syntak-dasar-sql-server.html" rel="nofollow" target="_blank">Syntak Dasar SQL </a> </span>Secara umum, SQL terdiri dari dua bahasa, yaitu</span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;"><b><i> </i></b></span><span style="color: black; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt;"><b><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;">Data Definition</span> Language</span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> (DDL)</span></i></b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> dan </span><a href="http://id.wikipedia.org/w/index.php?title=Data_Manipulation_Language&action=edit&redlink=1" style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" title="Data Manipulation Language (halaman belum tersedia)"><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;"><b>Data</b><span style="font-style: normal;"> </span><b>Manipulation Language</b></span></span></i></a><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><i><b> (DML). </b></i></span></span></div>
<div class="post-body entry-content" style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; width: 580px;">
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">baiklah saya akan menjelaskan pengertian Data Definition Language (DDL) dan Data Manipulation Language(DML)</span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><i>Data Definition Language</i><span style="font-style: normal; font-weight: 100;"><o:p></o:p></span></span></span></b></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">DDL digunakan untuk mendefinisikan, mengubah, serta menghapus </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">basis data</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> dan objek-objek yang diperlukan dalam basis data, misalnya </span><i><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">tabel</span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">view</span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">user</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">, dan sebagainya. Secara umum, DDL yang digunakan adalah </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>CREATE</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk membuat objek baru, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>USE</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk menggunakan objek, </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>ALTER</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk mengubah objek yang sudah ada, dan </span><span style="border: 0px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>DROP</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> untuk menghapus objek. DDL biasanya digunakan oleh </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">administrator</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> basis data dalam pembuatan sebuah </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">aplikasi</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"> basis data.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>CREATE</b></span><b style="font-weight: 100;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>CREATE</b></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: lime;"> </span>digunakan untuk membuat basis data maupun objek-objek basis data. SQL yang umum digunakan adalah:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; line-height: 20.796875px;"><b><span style="font-family: Georgia, Times New Roman, serif;">CREATE DATABASE nama_basis_data</span></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="background-color: #f9f9f9; line-height: 20.796875px;"><b><span style="font-family: Georgia, Times New Roman, serif;">CREATE TABLE nama_tabel</span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;"><b>CREATE TABLE</b></span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; vertical-align: baseline;"> membuat tabel baru pada basis data yang sedang aktif. Secara umum, perintah ini memiliki bentuk</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<b style="font-family: Georgia, 'Times New Roman', serif; line-height: 15.6pt;">CREATE TABLE [<i>nama_tabel</i>]</b></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>(<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>nama_field1 tipe_data [constraints][,<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>nama_field2 tipe_data,<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>...]<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><b>)</b></span></span></div>
</div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Keterangan :<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><i style="font-style: normal; font-weight: 100;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">nama_field</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah nama</span><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">kolom</span><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> (field)</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> yang akan dibuat. Beberapa sistem manajemen basis data mengizinkan penggunaan spasi dan karakter nonhuruf pada nama kolom.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><i style="font-style: normal;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">tipe_data</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> tergantung implementasi sistem manajemen basis data. Misalnya, pada </span><a href="http://id.wikipedia.org/wiki/MySQL" style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" title="MySQL"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;">MySQL</span></span></a><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, tipe data dapat berupa </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">VARCHAR</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">TEXT</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">BLOB</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">ENUM</span></i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>, dan sebagainya.</i><o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><i style="font-style: normal;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">constraints</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah batasan-batasan yang diberikan untuk tiap kolom. Ini juga tergantung implementasi sistem manajemen basis data, misalnya </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">NOT NULL</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">UNIQUE</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">,</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> dan sebagainya. Ini dapat digunakan untuk mendefinisikan </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>kunci primer</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> (<i>primary key</i>) dan </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">kunci </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;">tamu</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> (<i>foreign key</i>).<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Satu tabel boleh tidak memiliki kunci primer sama sekali, namun sangat disarankan mendefinisikan paling tidak satu kolom sebagai kunci primer.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b></b></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">CREATE TABLE user<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">(<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">username VARCHAR(15) CONSTRAINT PRIMARY KEY,<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">password VARCHAR(20) NOT NULL,<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">tgl_lahir DATETIME<o:p></o:p></span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">);</span></span></b></span></div>
<span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>
</b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">akan membuat tabel </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">user</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> seperti berikut:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="background-color: #f9f9f9; border-collapse: collapse; border: none; margin: 0px; padding: 0px; text-align: center; vertical-align: baseline;"><tbody style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><u><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">username</span></u></b><b><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">password<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">tgl_lahir</span></span></b></div>
</td></tr>
</tbody></table>
</div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 18pt;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<a href="http://id.wikipedia.org/w/index.php?title=Data_Manipulation_Language&action=edit&redlink=1" style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 24px; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" title="Data Manipulation Language (halaman belum tersedia)"><i><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="color: black;"><b>Data</b><span style="font-style: normal;"> </span><b>Manipulation Language</b></span></span></i></a><span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 18pt;"><br />DML digunakan untuk memanipulasi data yang ada dalam suatu tabel. Perintah yang umum dilakukan adalah: </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Data Manipulation Language<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;">  </span></span></span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">untuk menampilkan data<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">INSERT</span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk menambahkan data baru</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-weight: 100; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><b>UPDATE</b></span><span style="border: 0px; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><b> </b>untuk mengubah data yang sudah ada</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">DELETE</span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">untuk menghapus data<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span></b><b style="font-weight: 100;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b style="font-style: normal;"><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">adalah perintah yang paling sering digunakan pada SQL,</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>SELECT</b></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> digunakan untuk menampilkan data dari satu atau lebih tabel, biasanya dalam sebuah basis data yang sama. Secara umum, perintah </span><span style="border: 0px; font-style: normal; margin: 0px; padding: 0px; vertical-align: baseline;"><b>SELECT</b></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> memiliki bentuk lengkap: ( </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>QUERY BUDIN</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> )</span></span></div>
<div class="MsoNormal" style="border: 0px; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT [nama_tabel|alias.]nama_field1 [AS alias1] [, nama_field2, ...]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM nama_tabel1 [AS alias1] [INNER|LEFT|RIGHT JOIN tabel2 ON <i>kondisi_penghubung</i>]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[, nama_tabel3 [AS alias3], ...]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[WHERE <i>kondisi</i>]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[ORDER BY nama_field1 [ASC|DESC][, nama_field2 [ASC|DESC], ...]]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[GROUP BY nama_field1[, nama_field2, ...]]<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">[HAVING <i>kondisi_aggregat</i>]</span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Keterangan :</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">kondisi</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah syarat yang harus dipenuhi suatu data agar ditampilkan.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><i style="font-style: normal;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">kondisi_aggregat</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> adalah syarat khusus untuk </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"><i>fungsi aggregat</i></span></span></div>
<div class="MsoNormal" style="border: 0px; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">Kondisi dapat dihubungkan dengan </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><i>operator logika</i></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, misalnya </span><i><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">AND</span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, </span><span style="border: 0px; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">OR</span></i><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, dan sebagainya.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">Diasumsikan terdapat tabel </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">user</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> yang berisi data sebagai berikut.<o:p></o:p></span></span></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="background-color: #f9f9f9; border-collapse: collapse; border: none; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><tbody style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">username</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">password<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">tgl_lahir<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">jmlh_trans<o:p></o:p></span></span></b></div>
</td><td style="background-color: #f2f2f2; border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div align="center" class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; text-align: center; vertical-align: baseline;">
<b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">total_trans<o:p></o:p></span></span></b></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Abdi</span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">6487AD5EF<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">19-09-1997<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">6<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">10.000<o:p></o:p></span></span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Bagoes<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">97AD4erD<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">21-11-1994<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">3</span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">33.000</span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Chairul<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">548794654<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">06-08-1990<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">24<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">312.150<o:p></o:p></span></span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Dani<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FLKH947HF<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">02-04-1990<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">5</span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">12000</span></div>
</td></tr>
<tr style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><td style="border: 1pt solid rgb(170, 170, 170); font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Eka<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">94RER54<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">15-08-1995<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">34<o:p></o:p></span></span></div>
</td><td style="border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1pt; border-right-color: rgb(170, 170, 170); border-right-width: 1pt; border-style: none solid solid none; font-style: normal; font-weight: 100; margin: 0px; padding: 2.4pt; vertical-align: baseline;"><div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: normal; margin: 12pt 0in; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">50.000<o:p></o:p></span></span></div>
</td></tr>
</tbody></table>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh Pertama : Cara tampilkan seluruh data.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT *<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 2: Tampilkan pengguna yang memiliki jumlah transaksi lebih dari 5</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT *<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">WHERE jmlh_trans > 5</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 3: Tampilkan username pengguna yang bertransaksi kurang dari 10 dan nilainya lebih dari 1.000.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT username<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">WHERE jmlh_trans < 10 AND total_trans > 700</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 4: Tampilkan total nominal transaksi yang sudah terjadi.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT SUM(total_trans) AS total_nominal_transaksi<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh 5: Tampilkan seluruh data diurutkan berdasarkan jumlah transaksi terbesar ke terkecil.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT *<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">ORDER BY jmlh_trans DESC</span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b><br /></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Fungsi aggregat<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Beberapa SMBD memiliki fungsi aggregat, yaitu fungsi-fungsi khusus yang melibatkan sekelompok data (aggregat). Secara umum fungsi aggregat adalah:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">SUM</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk menghitung total nominal data<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">COUNT</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk menghitung jumlah kemunculan data</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; line-height: normal; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></span></span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">AVG</span><span style="border: 0px; font-family: Georgia, 'Times New Roman', serif; line-height: 18pt; margin: 0px; padding: 0px; text-indent: -0.25in; vertical-align: baseline;"> untuk menghitung rata-rata sekelompok data</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 0px 0px 1.2pt 0.25in; padding: 0px; text-indent: -0.25in; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">MAX</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> dan </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">MIN</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"> untuk mendapatkan nilai maksimum/minimum dari sekelompok data.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">Fungsi aggregat digunakan pada bagian </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">. Syarat untuk fungsi aggregat diletakkan pada bagian </span><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">HAVING</span></b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">, bukan </span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">WHERE</span><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><b>Subquery<o:p></o:p></b></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Ada kalanya <i>query</i> dapat menjadi kompleks, terutama jika melibatkan lebih dari satu tabel dan/atau fungsi aggregat. Beberapa SMBD mengizinkan penggunaan <i>subquery</i>. Contoh:<o:p></o:p></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Tampilkan username pengguna yang memiliki jumlah transaksi terbesar.</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"></span><br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT username<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">WHERE jmlh_trans =<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">(<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<br />
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">SELECT MAX(jmlh_trans)<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</span>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">FROM user<o:p></o:p></span></span></span></div>
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">)</span></span></div>
<div class="MsoNormal" style="background-color: #f9f9f9; border: none; line-height: 15.6pt; margin: 0px 0px 0in; padding: 0in; vertical-align: baseline;">
<span style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;"><br /></span></span></div>
</span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">INSERT</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">INSERT digunakan untuk menyimpan data dalam tabel dengan sintaks sebagai berikut :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">INSERT INTO [NAMA_TABLE] (NAMA_FIELD1,NAMA_FIELD2, NAMA_FIELD3) VALUES ('NILAI1', 'NILAI2', 'NILAI3');</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 20.796875px;">Contoh :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 20.796875px;">INSERT INTO tbl_user (nama,alamat,password) VALUES ('Dwi Randy Herdinanto','Bandar Jaya','pass123')</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><span style="line-height: 20.796875px;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">UPDATE</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Update digunakan untuk mengubah data dengan syntak sebagai berikut :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">UPDATE [NAMA_TABLE] SET [NAMA_FIELD]=[NILAI] WHERE [KONDISI]</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">UPDATE tbl_user set password="pass123" where username="test"</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;"><br /></span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 20.75pt; margin: 0px 0px 0.05in; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">DELETE</span></b><b><span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><o:p></o:p></span></b></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Delete digunakan untuk menghapus data dengan syntak sebagai berikut :</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">DELETE FROM [NAMA TABLE] WHERE [KONDISI]</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="font-family: Georgia, Times New Roman, serif;">Contoh:</span></span></div>
<div class="MsoNormal" style="border: 0px; font-style: normal; font-weight: 100; line-height: 18pt; margin: 4.8pt 0in 6pt; padding: 0px; vertical-align: baseline;">
<span style="border: 0px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: #f9f9f9; font-family: Georgia, 'Times New Roman', serif; line-height: 20.796875px;">DELETE FROM TEST WHERE NAMA='test';</span></span></div>
<div class="MsoNormal" style="border: 0px; font-family: inherit; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; clear: both; font-family: inherit; font-size: 13px; font-style: normal; font-weight: 100; margin: 0px; padding: 0px; vertical-align: baseline;">
</div>
</div>