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 `detailjual`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
nota_jual kode_brng kode_sat h_jual h_beli jumlah subtotal dis bsr_dis tambahan embalase tuslah aturan_pakai total no_batch no_faktur
PJ20250414001 B000000557 TAB 1111 926 10 11110 0 0 0 0 0 11110
PJ20250428001 B000000556 TAB 1367 1138 10 13670 0 0 0 0 0 13670
PJ20250603001 B000000556 TAB 1367 1138 10 13670 0 0 0 0 0 13670
PJ20250603001 A000000001 GLN 158400 132000 10 1584000 0 0 0 0 0 1584000
PJ20250826001 B000002026 TAB 4393 3661 10 43930 0 0 0 0 0 43930
PJ20250913001 B000000575 CAP 4835 3223 10 48350 0 0 0 0 0 48350
PJ20250913001 B000000965 TAB 533 444 10 5330 0 0 0 0 0 5330
PJ20250917001 B000000556 TAB 1367 1138 10 13670 0 0 0 0 0 13670
PJ20250917001 B00001000 CAP 6660 5550 10 66600 0 0 0 0 0 66600
PJ20251103001 B000000791 TAB 1479 1232 10 14790 0 0 0 0 0 14790
PJ20251103001 B000000557 TAB 1111 926 10 11110 0 0 0 0 0 11110
PJ20251103001 B000000305 TAB 160 133 10 1600 0 0 0 0 0 1600
PJ20251211001 B000000791 TAB 1479 1232 10 14790 0 0 0 0 0 14790
PJ20260107001 B000001746 ML 816 680 10 8160 0 0 0 0 0 8160
PJ20260107001 A000000002 BTL 84000 63800 1 84000 0 0 0 0 0 84000
PJ20260109001 B000000791 TAB 1479 1232 10 14790 0 0 0 0 0 14790
PJ20260109001 B000000575 CAP 4835 3223 10 48350 0 0 0 0 0 48350
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