Query Menghapus Data Dalam Tabel Database Siadpa Plus

Query tersebut dibawah adalah perintah-perintah permintaan untuk menghapus data yang ada dalam database sesuai dengan data apa yang ingin dihapus didalam database siadpawin.

Menghapus Jenis Putusan perkara belum putus :

UPDATE DATA_REGISTER SET JENIS_P=NULL WHERE NO_PERK='0123G15'

Menghapus Akta Cerai salah simpan :

DELETE FROM DATA_REG_AC WHERE NO_PERK='0001G12'

Copy and WIN : http://bit.ly/copynwin

DELETE FROM DATA_REG_AC WHERE NO_PERK='0001G15'

DELETE FROM DATA_REG_AC WHERE NO_PERK='0001G12'

Copy and WIN : http://bit.ly/copynwin

DELETE FROM DATA_REG_AC WHERE NO_PERK='0001G12'

Copy and WIN : http://bit.ly/copynwin

DELETE FROM DATA_REG_AC WHERE NO_PERK='0001G12'

Copy and WIN : http://bit.ly/copynwin

Menghapus perkara per-nomor perkara :

DELETE FROM DATA_REGISTER WHERE NO_PERK='0123G15'

Menghapus perkara pertahun :

DELETE FROM DATA_REGISTER WHERE CAST(RIGHT(NO_PERK,2) AS INTEGER) = 13

Query diatas bersumber dari agan master Laskar Siadpa Plus dan terima kasih agan master Laskar Siadpa Plus telah bekerja keras, kerja cerdas, kerja ihklas.

DELETE
DELETE FROM DATA_REG_AC WHERE NO_PERK='0001G12FROM DATA_REGISTER WHERE NO_PERK = 896G11

Copy and WIN : http://bit.ly/copynwin

DELETE FROM DATA_REG_AC WHERE NO_PERK='0001G12'

Copy and WIN : http://bit.ly/copynwin