Tugas Ku Perintah Delete

1 DELETE FROM [dbretail].[dbo].[tbbarang]
     WHERE id='9'
GO



2 DELETE FROM [dbretail].[dbo].[tbbarang]
     WHERE idsatuan='4' or idsatuan='5'
GO




3 use dbretail

delete from tbbarang
where namabarang='sandal jepit'



4 use dbretail

delete
from tbbarang
where namabarang='sepatu' or id='3'


5 use dbretail

delete
from tbbarang
where status='T'



6 use dbretail
delete
from tbbarang
where id > 6

7 use dbretail

delete
from tbbarang
where hbeli=hjual


8 use dbretail
delete
from tbbarang
where hjual >= 100000

9 use dbretail

delete
from tbsatuan
where id>=12

10 use dbretail

delete
from tbsatuan
where keterangan='EA'