Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: drugissue_amounts
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (455660 total, Query took 0.0004 seconds.)
SELECT * FROM `drugissue_amounts`

Full texts id drugissue_id presc_no rate total_amt net_amount discount discount_indicator discount_payment total_pck_serv_amnt created_date created_by modified_date modified_by discount_last_type discount_last_val taxAmount_tot round_off round_off_amt locationname total_discount net_amount1
1 1 NULLNULLNULLNULL0.00 0.00 0.00 2017-06-29 11:22:07 000001 NULLNULLF 0.00 NULL+ NULLAPH 0.00 0.00
2 2 NULLNULL672.67 650.00 0.00 0.00 0.00 2017-06-30 12:02:50 000020 NULLNULLP 8.00 33.63 + 0.20 APH 0.00 0.00
3 3 NULLNULL672.67 650.00 0.00 0.00 0.00 2017-06-30 14:15:42 000020 NULLNULLP 8.00 33.63 + 0.20 APH 0.00 0.00
4 4 NULLNULL16258.07 15705.29 0.00 0.00 0.00 2017-06-30 14:37:24 000020 NULLNULLP 8.00 812.90 + NULLAPH 1365.68 0.00
5 5 NULLNULL9299.45 8983.28 0.00 0.00 0.00 2017-06-30 14:56:42 000020 NULLNULLP 8.00 484.04 + NULLAPH 0.00 0.00
6 6 NULLNULL1828.47 1766.31 0.00 0.00 0.00 2017-06-30 15:00:25 000020 NULLNULLP 8.00 91.43 + NULLAPH 0.00 0.00
7 7 NULLNULL5528.40 5340.43 0.00 0.00 0.00 2017-06-30 17:58:44 000020 NULLNULLP 8.00 276.42 + NULLAPH 0.00 0.00
8 8 NULLNULL1675.91 1618.92 0.00 0.00 0.00 2017-06-30 18:05:57 000020 NULLNULLP 8.00 83.79 + NULLAPH 0.00 0.00
9 9 NULLNULL239.18 231.00 0.00 0.00 0.00 2017-07-01 10:02:34 000020 NULLNULLP 8.00 11.97 - 0.06 APH 20.09 0.00
10 10 NULLNULL391.95 379.00 0.00 0.00 0.00 2017-07-01 10:10:21 000020 NULLNULLP 8.00 19.59 + 0.38 APH 32.92 0.00
11 11 NULLNULL194.02 188.00 0.00 0.00 0.00 2017-07-01 10:13:12 000020 NULLNULLP 8.00 9.70 + 0.58 APH 16.30 0.00
12 12 NULLNULL259.26 251.00 0.00 0.00 0.00 2017-07-01 10:15:26 000020 NULLNULLP 8.00 12.96 + 0.56 APH 21.78 0.00
13 13 NULLNULL278.10 269.00 0.00 0.00 0.00 2017-07-01 10:18:04 000020 NULLNULLP 8.00 13.90 + 0.36 APH 23.36 0.00
14 14 NULLNULL356.14 344.00 0.00 0.00 0.00 2017-07-01 10:21:07 000020 NULLNULLP 8.00 17.80 - 0.02 APH 29.92 0.00
15 15 NULLNULL178.10 172.00 0.00 0.00 0.00 2017-07-01 10:23:07 000020 NULLNULLP 8.00 8.90 - 0.04 APH 14.96 0.00
16 16 NULLNULL112.38 109.00 0.00 0.00 0.00 2017-07-01 10:25:03 000020 NULLNULLP 8.00 5.62 + 0.44 APH 9.44 0.00
17 17 NULLNULL93.81 91.00 0.00 0.00 0.00 2017-07-01 10:26:40 000020 NULLNULLP 8.00 4.69 + 0.38 APH 7.88 0.00
18 18 NULLNULL343.81 332.00 0.00 0.00 0.00 2017-07-01 10:28:52 000020 NULLNULLP 8.00 17.19 - 0.12 APH 28.88 0.00
19 19 NULLNULL348.10 336.00 0.00 0.00 0.00 2017-07-01 10:31:46 000020 NULLNULLP 8.00 17.40 - 0.26 APH 29.24 0.00
20 20 NULLNULL163.18 158.00 0.00 0.00 0.00 2017-07-01 10:34:36 000020 NULLNULLP 8.00 8.16 + 0.37 APH 13.71 0.00
21 21 NULLNULL197.14 190.00 0.00 0.00 0.00 2017-07-01 10:37:29 000020 NULLNULLP 8.00 9.86 - 0.44 APH 16.56 0.00
22 22 NULLNULL159.05 154.00 0.00 0.00 0.00 2017-07-01 10:40:21 000020 NULLNULLP 8.00 7.95 + 0.36 APH 13.36 0.00
23 23 NULLNULL153.33 148.00 0.00 0.00 0.00 2017-07-01 10:42:01 000020 NULLNULLP 8.00 7.67 - 0.12 APH 12.88 0.00
24 24 NULLNULL93.81 91.00 0.00 0.00 0.00 2017-07-01 10:43:33 000020 NULLNULLP 8.00 4.69 + 0.38 APH 7.88 0.00
25 25 NULLNULL224.76 217.00 0.00 0.00 0.00 2017-07-01 10:46:50 000020 NULLNULLP 8.00 11.24 - 0.12 APH 18.88 0.00