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