select * from pegawai
select NIP,nama,Alamat,gajipokok from pegawai
where Alamat = 'Surabaya'or Alamat='Mojokerto'
select NIP,nama,Alamat,gajipokok from pegawai
where gajipokok < 400000
create table Mahasiswi(
NIP char (6) primary key,
Nama varchar (30),
Alamat varchar (35),
Telp varchar(15) ,
Email varchar (20), )
go
select * from Mahasiswi
insert into Mahasiswi values ('K001','silvy','surabaya','031-5656787','silvy@ymail.com','Papsi')
insert into Mahasiswi values ('K002','Hendra','surabaya','031-5356787','Hendra@ymail.com','Matematika')
alter table Mahasiswi
add jurusan varchar (o30)
insert into Mahasiswi values ('K001','silvy','surabaya','031-5656787','silvy@ymail.com','Papsi')
insert into Mahasiswi values('K002','Hendra','surabaya','031-5356787','Hendra@ymail.com','Matematika')
Select * from pegawai
select NIP,nama,gajipokok,Tunj_Gol from pegawai,Golongan
where pegawai.Gol = Golongan.Gol

alamaq

select * from pegawai
select NIP,nama,gajipokok from pegawai
select NIP,nama,gajipokok from pegawai
where gajipokok < 2000000
select * from pegawai
where jk= 'p'or gajipokok<2000000
select * from pegawai
where not jk= 'p'
select NIP,nama,gajipokok from pegawai
where gajipokok between 175000 and 3000000
select NIP,nama,gajipokok from pegawai
where nama like 'f%'
select NIP,nama,gajipokok from pegawai
where nama like '%i'
select NIP,nama,gajipokok from pegawai
where nama like '%i%'
select NIP,nama,alamat from pegawai
where alamat in 'surabaya'
select * from pegawai
order by nama asc
select * from pegawai
order by nama desc]
select distinct alamat from pegawai
select avg (gajipokok)'rata-rata gaji pokok' from pegawai
select nama,jabatan,gajipokok from pegawai
where gajipokok= (select max (gajipokok) from pegawai)
select nama,jabatan,gajipokok from pegawai
where gajipokok= (select min (gajipokok) from pegawai)
select count(*) "banyak pegawai" from pegawai
select sum(gajipokok)"total gaji" from pegawai
select *from pegawai
select pegawai.nip,pegawai.nama,pegawai.gaji_pokok,golongan.Tunj_Gol from pegawai,golongan
select * from pegawai where gaji_pokok > 600000
update Golongan
set Tunj_Gol =('0,5'* Tunj_Gol )+ Tunj_Gol
select * from Golongan
select NIP,nama,gajipokok,Tunj_Gol
from pegawai,Golongan
where pegawai.Gol = Golongan.Gol
create table pagawai( kode varchar (10) primary key, )