Pertemuan 11

FUNGSI

Create Database TokoBuku
use TokoBuku

Create Table Penerbit(
Kd_Penerbit char(5)Primary Key,
Nama_Penerbit Varchar(25))
Select*From Penerbit

Insert into Penerbit Values('001','ANDI')
Insert into Penerbit Values('005','INDAH')
Insert into Penerbit Values('006','ERLANGGA')

Create Table Buku1(
Kd_Buku Char(5)Primary key,
Kd_Penerbit Char (5)References Penerbit(Kd_Penerbit),
Judul Varchar (30),
Pengarang Varchar (25),
Stok Int,
Kategori Varchar (15))
Select*From Buku1

Insert into Buku1 Values('DES01','001','Corel Draw 12','Taufig Hidayatullah','100','BAIK')
Insert into Buku1 Values('AD04','005','Corel Draw X3','Desman Siahaan S.KOM','100','SANGAT BAIK')
Insert into Buku1 Values('TKC02','006','Microsoft Excel','Yanti Tampubolon','50','BAIK')

Select Count (*) From Buku1
Select SUM (Stok) From Buku1
Select AVG (Stok) From Buku1
Select MAX (Stok) From Buku1
Select MIN (Stok) From Buku1

Select Count (*) From BUku1 Where Judul like 'C%'
Select SUM (Stok) From Buku1 Where Kategori ='Sangat Baik'
Select AVG (Stok) From Buku1 Where Kategori='Baik'

Select ABS (-496)

Select Ceiling (496.45)
Select Floor (496.65)
Select Power (2,4)
Select Round (224.9980,0)
Select Substring('Interaktive',6,5)
Select LTRIM ('  Praktikum')
Select 'Selamt' + 'Belajar'

1.Fungsi Pembuatan Keatas
Select Ceiling(3.247)
Select Ceiling(3.87)

2.Fungsi Pembuatan Kebawah
Select floor(3.247)
Select floor(3.87)

3.Fungsi Pembulatan
Select Round(4.8731,0)
Select Round(4.8731,1)
Select Round(4.8731,2)
Select Round(4.8731,3)
Select Round(4.8731,4)

4.Fungsi Pangkat
Select Power(2,2)
Select Power(2,3)
Select Power(2,4)

5.Fungsi Akar
Select Sqrt(4)
Select Sqrt(100)
Select Sqrt(225)