Senin, 14 Maret 2011

Query For SBDL

Langsung Saja Teman-teman SBD L yang cerewet terutama NIM 672010110 (ha-ha-ha)
nyoh silakan copy query ke SQL kalian
select*from mahasiswa
create table mahasiswa
(
    nim varchar(20) primary key not null,
    nama varchar(50),
    tempat_lahir varchar(50),
    TTL datetime,
    matakuliah1 varchar(20),
    matakuliah2 varchar(20),
    uang_semester int
)
insert into mahasiswa values('672010010','ALVIN ADRIAN PUTRA','Kupang','1992-10-02 00:00:00.000','SBDA','ASDB',1150000)
insert into mahasiswa values('672010110','HARESTU PRAMADHANA','Salatiga','1992-12-22 00:00:00.000','SBDB','ASDI',1000000)
insert into mahasiswa values('672010208','YONIF DWI PRASETYO','Salatiga','1991-01-04 00:00:00.000','SBDA','ASDI',500000)
insert into mahasiswa values('682010007','YOHANNA AMELIA','Solo','1992-09-13 00:00:00.000','SBDA','ASDB',750000)
insert into mahasiswa values('682010066','INDRA PERMANA KUSUMA','Salatiga','1991-08-12 00:00:00.000','SBDC','ASDI',1150000)
insert into mahasiswa values('692010009','CHRISTIAN RAHARDJO','Solo','1992-01-31 00:00:00.000','SBDB','ASDB',1150000)
insert into mahasiswa values('702010142','ARI WIDODO','Temanggung','1991-07-07 00:00:00.000','SBDC','ASDC',800000)
insert into mahasiswa values('702010151','WONO ADVEN','Salatiga','1992-03-01 00:00:00.000','SBDA','ASDB',150000)
select*from mahasiswa

0 komentar: