Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah Time taken
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :
Modus jelajah

Atur mode jelajah.

Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Whether a user should be displayed a "show all (rows)" button.
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan.
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya.
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse.
Dokumentasi Sorot baris terpilih.
Dokumentasi
Dokumentasi
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini.
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah.
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus.
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key.
Dokumentasi Default sort order for tables with a primary key.
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat.
Dokumentasi Untuk pengaturan tampilan
SELECT * FROM `periksa_lab`
[ Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
|
|
|
Saring baris:
Sort by key:
Teks penuh no_rawat nip kd_jenis_prw tgl_periksa jam dokter_perujuk bagian_rs bhp tarif_perujuk tarif_tindakan_dokter tarif_tindakan_petugas kso menejemen biaya kd_dokter status kategori
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/29/000002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000004\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'11:19:00\'
 		2020/06/29/000002 025 J000004 2020-07-16 11:19:00 1801018001 44922 20078 0 0 15000 0 0 80000 1801018001 Ranap PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/29/000002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000011\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'11:19:00\'
 		2020/06/29/000002 025 J000011 2020-07-16 11:19:00 1801018001 10450 2550 0 0 5000 0 0 18000 1801018001 Ranap PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/29/000002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000012\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'11:19:00\'
 		2020/06/29/000002 025 J000012 2020-07-16 11:19:00 1801018001 10792 2208 0 0 5000 0 0 18000 1801018001 Ranap PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/29/000002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000020\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'11:19:00\'
 		2020/06/29/000002 025 J000020 2020-07-16 11:19:00 1801018001 26150 8850 0 0 5000 0 0 40000 1801018001 Ranap PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/30/000001\' AND `periksa_lab`.`kd_jenis_prw` = \'J000011\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'13:52:36\'
 		2020/06/30/000001 025 J000011 2020-07-16 13:52:36 1801018001 10450 2550 0 0 5000 0 0 18000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/30/000001\' AND `periksa_lab`.`kd_jenis_prw` = \'J000012\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'13:52:36\'
 		2020/06/30/000001 025 J000012 2020-07-16 13:52:36 1801018001 10792 2208 0 0 5000 0 0 18000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/30/000001\' AND `periksa_lab`.`kd_jenis_prw` = \'J000020\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'13:52:36\'
 		2020/06/30/000001 025 J000020 2020-07-16 13:52:36 1801018001 26150 8850 0 0 5000 0 0 40000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/06/30/000001\' AND `periksa_lab`.`kd_jenis_prw` = \'J000026\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'13:52:36\'
 		2020/06/30/000001 025 J000026 2020-07-16 13:52:36 1801018001 43500 16500 0 0 10000 0 0 70000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000003\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:33:54\'
 		2020/07/01/00002 025 J000003 2020-07-16 08:33:54 1801018001 26110 8890 0 0 5000 0 0 40000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000004\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:33:54\'
 		2020/07/01/00002 025 J000004 2020-07-16 08:33:54 1801018001 44922 20078 0 0 15000 0 0 80000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000018\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:33:54\'
 		2020/07/01/00002 025 J000018 2020-07-16 08:33:54 1801018001 29500 5500 0 0 10000 0 0 45000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000019\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:33:54\'
 		2020/07/01/00002 025 J000019 2020-07-16 08:33:54 1801018001 31561 3439 0 0 10000 0 0 45000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000020\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:33:54\'
 		2020/07/01/00002 025 J000020 2020-07-16 08:33:54 1801018001 26150 8850 0 0 5000 0 0 40000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00006\' AND `periksa_lab`.`kd_jenis_prw` = \'J000003\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:50:52\'
 		2020/07/01/00006 1801018052 J000003 2020-07-16 08:50:52 1801018002 26110 8890 0 0 5000 0 0 40000 1801018002 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00006\' AND `periksa_lab`.`kd_jenis_prw` = \'J000004\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:50:52\'
 		2020/07/01/00006 1801018052 J000004 2020-07-16 08:50:52 1801018002 44922 20078 0 0 15000 0 0 80000 1801018002 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00006\' AND `periksa_lab`.`kd_jenis_prw` = \'J000020\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:50:52\'
 		2020/07/01/00006 1801018052 J000020 2020-07-16 08:50:52 1801018002 26150 8850 0 0 5000 0 0 40000 1801018002 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/00006\' AND `periksa_lab`.`kd_jenis_prw` = \'J000048\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:50:52\'
 		2020/07/01/00006 1801018052 J000048 2020-07-16 08:50:52 1801018002 22500 17500 0 0 10000 0 0 50000 1801018002 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/7\' AND `periksa_lab`.`kd_jenis_prw` = \'J000004\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:53:30\'
 		2020/07/01/7 1801018052 J000004 2020-07-16 08:53:30 1801018002 44922 20078 0 0 15000 0 0 80000 1801018002 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/7\' AND `periksa_lab`.`kd_jenis_prw` = \'J000008\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:53:30\'
 		2020/07/01/7 1801018052 J000008 2020-07-16 08:53:30 1801018002 52600 7400 0 0 5000 0 0 65000 1801018002 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/01/7\' AND `periksa_lab`.`kd_jenis_prw` = \'J000020\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:53:30\'
 		2020/07/01/7 1801018052 J000020 2020-07-16 08:53:30 1801018002 26150 8850 0 0 5000 0 0 40000 1801018002 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/02/000001\' AND `periksa_lab`.`kd_jenis_prw` = \'J000004\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-02\' AND `periksa_lab`.`jam` = \'15:20:19\'
 		2020/07/02/000001 1801018014 J000004 2020-07-02 15:20:19 D15 44922 20078 0 0 15000 0 0 80000 D15 Ranap PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/02/000036\' AND `periksa_lab`.`kd_jenis_prw` = \'J000003\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:28:44\'
 		2020/07/02/000036 025 J000003 2020-07-16 08:28:44 1801018001 26110 8890 0 0 5000 0 0 40000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/02/000036\' AND `periksa_lab`.`kd_jenis_prw` = \'J000020\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'08:28:44\'
 		2020/07/02/000036 025 J000020 2020-07-16 08:28:44 1801018001 26150 8850 0 0 5000 0 0 40000 1801018001 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/03/000002\' AND `periksa_lab`.`kd_jenis_prw` = \'J000052\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'14:08:42\'
 		2020/07/03/000002 025 J000052 2020-07-16 14:08:42 D16 80000 100000 0 0 20000 0 0 200000 D16 Ralan PA
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM `periksa_lab` WHERE `periksa_lab`.`no_rawat` = \'2020/07/04/000004\' AND `periksa_lab`.`kd_jenis_prw` = \'J000004\' AND `periksa_lab`.`tgl_periksa` = \'2020-07-16\' AND `periksa_lab`.`jam` = \'14:31:18\'
 		2020/07/04/000004 025 J000004 2020-07-16 14:31:18 D16 44922 20078 0 0 15000 0 0 80000 D16 Ralan PA
Dengan pilihan: Dengan pilihan:
|
|
|
Saring baris:
Sort by key:
Operasi hasil kueri Cetak Cetak Salin ke clipboard Salin ke clipboard Ekspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan
Markahi kueri SQL ini Markahi kueri SQL ini