Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `detail_surat_pemesanan_medis`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
no_pemesanan kode_brng kode_sat jumlah h_pesan subtotal dis besardis total jumlah2
SPM231121001 B000001780 PCS 100 2904 290400 0 0 290400 100
SPM231121001 B000001394 PCS 100 2000 200000 0 0 200000 100
SPM231121001 A000000002 BTL 10 70000 700000 0 0 700000 10
SPM231205001 B000000613 TAB 100 14652 1465200 0 0 1465200 100
SPM231205001 B000000620 TAB 400 2527 1010800 0 0 1010800 400
SPM231205001 B000001895 SYR 100 65000 6500000 0 0 6500000 100
SPM231205001 B000000625 TAB 100 7722 772200 0 0 772200 100
SPM240125001 B000001207 TAB 100 2750 275000 0 0 275000 100
SPM240125001 B000000557 TAB 100 926 92600 0 0 92600 100
SPM240205001 B000000578 CAP 100 317 31700 0 0 31700 100
SPM240205001 B000000159 TAB 50 10989 549450 0 0 549450 50
SPM240205001 B000000584 AMP5 100 1467 146700 0 0 146700 100
SPM240205001 B000000583 TAB 90 8800 792000 0 0 792000 90
SPM240315001 B000000157 TAB 70 100650 7045500 0 0 7045500 70
SPM240315001 B000001729 TAB 100 8044 804400 0 0 804400 100
SPM240315001 B000000569 INF 90 133100 11979000 0 0 11979000 90
SPM240315002 B000000555 AMP5 100 35431 3543100 0 0 3543100 100
SPM240315002 B000000558 SAL 100 6050 605000 0 0 605000 100
SPM240319001 B000000571 TAB 70 2521 176470 0 0 176470 70
SPM240319001 B00001000 CAP 100 4884 488400 0 0 488400 100
SPM240319001 B000000575 CAP 80 3630 290400 0 0 290400 80
SPM240319002 B000000575 CAP 100 3630 363000 0 0 363000 100
SPM240319003 B000000556 TAB 10 1138 11380 0 0 11380 10
SPM240319003 B000002033 BTL 10 36000 360000 0 0 360000 10
SPM240319004 B000001632 TAB 100 14500 1450000 0 0 1450000 100
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query