SELECT CONCAT( CASE DAYOFWEEK(NOW()) WHEN 1 THEN ‘Minggu’ WHEN 2 THEN ‘Senin’ WHEN 3 THEN ‘Selasa’ WHEN 4 THEN ‘Rabu’ WHEN 5 THEN ‘Kamis’ WHEN 6 THEN ‘Jumat’ WHEN 7 THEN ‘Sabtu’ END,’, ‘, DAY(NOW()),’ ‘, CASE MONTH(NOW()) WHEN 1 THEN ‘Januari’ WHEN 2 THEN ‘Februari’ WHEN 3 THEN ‘Maret’ WHEN 4 THEN ‘April’ WHEN
select `tahunajaran`.`tahunajaran` AS `tahunajaran`, `semester`.`semester` AS `semester`, `siswa`.`nis` AS `nis`, `siswa`.`nama` AS `siswa`, `pelajaran`.`nama` AS `mapel`, `dasarpenilaian`.`keterangan` AS `keterangan`, `nap`.`nilaiangka` AS `nilaiangka`, `nap`.`nilaihuruf` AS `nilaihuruf`, `nap`.`komentar` AS `komentar` from (((((((((`nap` join `infonap` on ((`nap`.`idinfo` = `infonap`.`replid`))) join `aturannhb` on ((`nap`.`idaturan` = `aturannhb`.`replid`))) join `pelajaran` on ((`aturannhb`.`idpelajaran` = `pelajaran`.`replid`))) join `semester` on ((`infonap`.`idsemester` = `semester`.`replid`))) join
select `tabel1`.`nip` AS `nip`, date_format(`tabel1`.`tgl`, ‘%d-%m-%Y’) AS `tanggal`, year (`tabel1`.`tgl`) AS `tahun`, (case when (month (`tabel1`.`tgl`) < 4) then ‘p1’ when (month (`tabel1`.`tgl`) < 7) then ‘p2’ when (month (`tabel1`.`tgl`) < 10) then ‘p3’ when (month (`tabel1`.`tgl`) < 13) then ‘p4’ end) AS `periode`, max((case when (`tabel1`.`no` = 1) then `tabel1`.`nilai` end)) AS `s1`, max((case
UPDATE t1 INNER JOIN `t2` ON (`t1`.`nip` = `t2`.`nip`) SET t1.id_jenis_jabatan = t2.`id_jenis_jabatan` WHERE `t1`.`id_jenis_jabatan` LIKE `t2`.`id_jenis_jabatan`
// Mencari Data 3 bulan Terakhir select * from tabelnya where tgl >= now()-interval 3 month