将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
SELECT * FROM `rozi_lembur_master` ORDER BY `mulai` DESC
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
过滤行:
按索引排序：
完整内容 id nip tahun_lembur bulan_lembur tanggal mulai 递减 递增 1 selesai status total_jam Keterangan
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 14040 AND `rozi_lembur_master`.`nip` = \'2206473\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'05\' AND `rozi_lembur_master`.`tanggal` = \'2025-05-22\' AND `rozi_lembur_master`.`mulai` = \'23:30:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		14040 2206473 2025 05 2025-05-22 23:30:00 23:59:59 Proses HRD 0.5 Pemindahan kabel jaringan di depan ruang tunggu ap...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 2366 AND `rozi_lembur_master`.`nip` = \'1706099\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'04\' AND `rozi_lembur_master`.`tanggal` = \'2024-04-20\' AND `rozi_lembur_master`.`mulai` = \'23:30:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		2366 1706099 2024 04 2024-04-20 23:30:00 23:59:59 Proses HRD 0.5 Menggantikan yogi mengantar dr. leo ke pku
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 10130 AND `rozi_lembur_master`.`nip` = \'1606069\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'12\' AND `rozi_lembur_master`.`tanggal` = \'2024-12-25\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		10130 1606069 2024 12 2024-12-25 23:00:00 23:59:59 Proses HRD 1 Lembur menggantikan yogi antar jenazah ke PKU
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 2075 AND `rozi_lembur_master`.`nip` = \'1603075\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'04\' AND `rozi_lembur_master`.`tanggal` = \'2024-04-14\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'04:00:00\'
 		2075 1603075 2024 04 2024-04-14 23:00:00 04:00:00 Proses HRD -19 LEMBUROPERASI DR MADUMA MENGGANTIKAN BANG NAZIRIN ...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 1328 AND `rozi_lembur_master`.`nip` = \'1706099\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'03\' AND `rozi_lembur_master`.`tanggal` = \'2024-03-20\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		1328 1706099 2024 03 2024-03-20 23:00:00 23:59:59 Proses HRD 1 Menggantikan syafnor merujuk ke pku
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 13709 AND `rozi_lembur_master`.`nip` = \'1906252\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'05\' AND `rozi_lembur_master`.`tanggal` = \'2025-05-04\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		13709 1906252 2025 05 2025-05-04 23:00:00 23:59:59 Proses HRD 1 mengantar pasien igd rontgen ke mutiasari
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 15152 AND `rozi_lembur_master`.`nip` = \'2506755\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'07\' AND `rozi_lembur_master`.`tanggal` = \'2025-07-14\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		15152 2506755 2025 07 2025-07-14 23:00:00 23:59:59 Proses HRD 1 LEMBUR MENGECAT LANTAI AREA APOTEK RAJAL
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 14442 AND `rozi_lembur_master`.`nip` = \'1706099\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'06\' AND `rozi_lembur_master`.`tanggal` = \'2025-06-04\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		14442 1706099 2025 06 2025-06-04 23:00:00 23:59:59 Proses HRD 1 Menggantikan rekan merujuk ke pekanbaru dan meruju...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 13224 AND `rozi_lembur_master`.`nip` = \'1706099\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'04\' AND `rozi_lembur_master`.`tanggal` = \'2025-04-17\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		13224 1706099 2025 04 2025-04-17 23:00:00 23:59:59 Proses HRD 1 Lembur Malam Menggantikan Syafnor merujuk
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 9601 AND `rozi_lembur_master`.`nip` = \'1906252\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'12\' AND `rozi_lembur_master`.`tanggal` = \'2024-12-07\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		9601 1906252 2024 12 2024-12-07 23:00:00 23:59:59 Proses HRD 1 Standby menggantikan manca merujuk ke PKU
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 14431 AND `rozi_lembur_master`.`nip` = \'1706099\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'06\' AND `rozi_lembur_master`.`tanggal` = \'2025-06-03\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		14431 1706099 2025 06 2025-06-03 23:00:00 23:59:59 Proses HRD 1 Menggantikan rekanan merujuk ke pekanbaru
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 1836 AND `rozi_lembur_master`.`nip` = \'1603075\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'04\' AND `rozi_lembur_master`.`tanggal` = \'2024-04-14\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'04:00:00\'
 		1836 1603075 2024 04 2024-04-14 23:00:00 04:00:00 Proses HRD -19 LEMBUR OPERASI DR ROSENO MENGGANTIKAN BANG NAZIRIN...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 7962 AND `rozi_lembur_master`.`nip` = \'2106344\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'10\' AND `rozi_lembur_master`.`tanggal` = \'2024-10-09\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:00\'
 		7962 2106344 2024 10 2024-10-09 23:00:00 23:59:00 Proses HRD 0.98 penurunan barang alkes dri pekanbaru ke ruko bersa...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 11878 AND `rozi_lembur_master`.`nip` = \'1706099\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'03\' AND `rozi_lembur_master`.`tanggal` = \'2025-03-09\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		11878 1706099 2025 03 2025-03-09 23:00:00 23:59:59 Proses HRD 1 Lembur malam menggantikan manca ke sumbar menganta...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 10481 AND `rozi_lembur_master`.`nip` = \'1606069\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'01\' AND `rozi_lembur_master`.`tanggal` = \'2025-01-12\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		10481 1606069 2025 01 2025-01-12 23:00:00 23:59:59 Proses HRD 1 Lembur menggantikan syafnor merujuk ke PKU
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 14582 AND `rozi_lembur_master`.`nip` = \'2106381\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'06\' AND `rozi_lembur_master`.`tanggal` = \'2025-06-02\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		14582 2106381 2025 06 2025-06-02 23:00:00 23:59:59 Proses HRD 1 Bersih-bersih depan depo apotik igd/ponek dan loro...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 18071 AND `rozi_lembur_master`.`nip` = \'2106381\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'10\' AND `rozi_lembur_master`.`tanggal` = \'2025-10-29\' AND `rozi_lembur_master`.`mulai` = \'23:00:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		18071 2106381 2025 10 2025-10-29 23:00:00 23:59:59 Proses HRD 1 LEMBUR MEMBERSIHKAN CAT DI KAMAR 210
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 17476 AND `rozi_lembur_master`.`nip` = \'2306606\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'10\' AND `rozi_lembur_master`.`tanggal` = \'2025-10-14\' AND `rozi_lembur_master`.`mulai` = \'22:59:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:00\'
 		17476 2306606 2025 10 2025-10-14 22:59:00 23:59:00 Proses HRD 1 Membantu dr ilhamtidak bisa menginput cppt dan upd...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 5508 AND `rozi_lembur_master`.`nip` = \'2306616\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'07\' AND `rozi_lembur_master`.`tanggal` = \'2024-07-30\' AND `rozi_lembur_master`.`mulai` = \'22:59:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:00\'
 		5508 2306616 2024 07 2024-07-30 22:59:00 23:59:00 Proses HRD 1 Perbaikan dan Pemantauan jaringan dikarenakn mikro...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 13926 AND `rozi_lembur_master`.`nip` = \'2306606\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'05\' AND `rozi_lembur_master`.`tanggal` = \'2025-05-22\' AND `rozi_lembur_master`.`mulai` = \'22:59:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:00\'
 		13926 2306606 2025 05 2025-05-22 22:59:00 23:59:00 Proses HRD 1 Memidahkan kabel jaringan di depan apotik rajal ka...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 14056 AND `rozi_lembur_master`.`nip` = \'2106344\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'05\' AND `rozi_lembur_master`.`tanggal` = \'2025-05-25\' AND `rozi_lembur_master`.`mulai` = \'22:30:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:00\'
 		14056 2106344 2025 05 2025-05-25 22:30:00 23:59:00 Proses HRD 1.48 bantu tukang bongkar atap apotik,lepas kabel,lepas...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 7930 AND `rozi_lembur_master`.`nip` = \'2306620\' AND `rozi_lembur_master`.`tahun_lembur` = 2024 AND `rozi_lembur_master`.`bulan_lembur` = \'10\' AND `rozi_lembur_master`.`tanggal` = \'2024-10-08\' AND `rozi_lembur_master`.`mulai` = \'22:30:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:00\'
 		7930 2306620 2024 10 2024-10-08 22:30:00 23:59:00 Proses HRD 1.48 pengarahan dan penataan barang alkes dari pekanbar...
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 14528 AND `rozi_lembur_master`.`nip` = \'1906252\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'06\' AND `rozi_lembur_master`.`tanggal` = \'2025-06-13\' AND `rozi_lembur_master`.`mulai` = \'22:30:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		14528 1906252 2025 06 2025-06-13 22:30:00 23:59:59 Proses HRD 1.5 Merujuk pasien IGD ke Permatahati
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 15314 AND `rozi_lembur_master`.`nip` = \'2106344\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'07\' AND `rozi_lembur_master`.`tanggal` = \'2025-07-14\' AND `rozi_lembur_master`.`mulai` = \'22:30:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		15314 2106344 2025 07 2025-07-14 22:30:00 23:59:59 Proses HRD 1.5 LANJUT CAT LANTAI APOTIK RAJAL LAPIS 2
编辑 编辑 复制 复制 删除 删除
DELETE FROM `rozi_lembur_master` WHERE `rozi_lembur_master`.`id` = 15310 AND `rozi_lembur_master`.`nip` = \'2106344\' AND `rozi_lembur_master`.`tahun_lembur` = 2025 AND `rozi_lembur_master`.`bulan_lembur` = \'07\' AND `rozi_lembur_master`.`tanggal` = \'2025-07-12\' AND `rozi_lembur_master`.`mulai` = \'22:30:00\' AND `rozi_lembur_master`.`selesai` = \'23:59:59\'
 		15310 2106344 2025 07 2025-07-12 22:30:00 23:59:59 Proses HRD 1.5 LANJUT CAT LANTAI APOTIK RAJAL
选中项： 选中项：
|
|
|
过滤行:
按索引排序：
查询结果操作 打印 打印 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签