Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: finalbills
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query
x
 
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
xxxxxxxxxx
 
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 (61203 total, Query took 0.0005 seconds.)
SELECT * FROM `finalbills`
SELECT * FROM `finalbills`

Full texts id bill_no bill_date patient_no mrno name bill_status admission_date conc_status discharge_status doctor_name total_amount bill_amount transaction_amount pending_amount_before_con pending_amount concession_value remark allow_pending created_date created_by locationname
1 BN/18/000001 2018-02-07 11:16:01 IP/18/000005 Mr ISU  KHAN B 2018-02-01 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:16:01 000012 AEH
2 BN/18/000002 2018-02-07 11:16:18 IP/18/000007 Mrs SHIV LALI B 2018-02-01 Y Y Dr Upendra Singh 7500.00 7500.00 7500.00 0.00 7500.00 0.00 NULL2018-02-07 11:16:18 000012 AEH
3 BN/18/000003 2018-02-07 11:16:37 IP/18/000010 Mrs JASKALA   B 2018-02-02 Y Y dr Anoop Mishra 10700.00 10700.00 10700.00 0.00 10700.00 0.00 NULL2018-02-07 11:16:37 000012 AEH
4 BN/18/000004 2018-02-07 11:16:43 IP/18/000011 Mr NARENDRA BAHADUR SINGH B 2018-02-02 Y Y dr Anoop Mishra 7500.00 7500.00 7500.00 0.00 7500.00 0.00 NULL2018-02-07 11:16:43 000012 AEH
5 BN/18/000005 2018-02-07 11:16:52 IP/18/000012 Mrs MURTA DEVI B 2018-02-06 Y Y dr Anoop Mishra 19700.00 19700.00 19700.00 0.00 19700.00 0.00 NULL2018-02-07 11:16:52 000012 AEH
6 BN/18/000006 2018-02-07 11:16:59 IP/18/000013 Mr SHAKIL  AHMAD B 2018-02-06 Y Y Dr Upendra Singh 7500.00 7500.00 7500.00 0.00 7500.00 0.00 NULL2018-02-07 11:16:59 000012 AEH
7 BN/18/000007 2018-02-07 11:17:14 IP/18/000014 Mr RAM MILAN   B 2018-02-06 Y Y Dr Upendra Singh 7500.00 7500.00 7500.00 0.00 7500.00 0.00 NULL2018-02-07 11:17:14 000012 AEH
8 BN/18/000008 2018-02-07 11:17:22 IP/18/000015 Mrs KAILASA DEVI B 2018-02-06 Y Y Dr Upendra Singh 1600.00 1600.00 1600.00 0.00 1600.00 0.00 NULL2018-02-07 11:17:22 000012 AEH
9 BN/18/000009 2018-02-07 11:17:28 IP/18/000016 Mr GYANMATI   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:17:28 000012 AEH
10 BN/18/000010 2018-02-07 11:17:35 IP/18/000017 Mrs HAMID   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:17:35 000012 AEH
11 BN/18/000011 2018-02-07 11:17:43 IP/18/000018 Smt BELA DEVI B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:17:43 000012 AEH
12 BN/18/000012 2018-02-07 11:17:49 IP/18/000019 Mr JAIRAM   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:17:49 000012 AEH
13 BN/18/000013 2018-02-07 11:17:56 IP/18/000020 Mrs ANARA   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:17:56 000012 AEH
14 BN/18/000014 2018-02-07 11:18:03 IP/18/000021 Mr PARTAP   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:18:03 000012 AEH
15 BN/18/000015 2018-02-07 11:18:13 IP/18/000023 Smt PIYARI        DEVI B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:18:13 000012 AEH
16 BN/18/000016 2018-02-07 11:18:21 IP/18/000024 Smt ANARA DEVI B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:18:21 000012 AEH
17 BN/18/000017 2018-02-07 11:18:29 IP/18/000027 Mr DHANAU   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:18:29 000012 AEH
18 BN/18/000018 2018-02-07 11:18:38 IP/18/000026 Smt DAULA   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:18:38 000012 AEH
19 BN/18/000019 2018-02-07 11:18:46 IP/18/000028 Mrs PHOOLWATI   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:18:46 000012 AEH
20 BN/18/000020 2018-02-07 11:19:08 IP/18/000029 Smt BHAGIRATI   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:19:08 000012 AEH
21 BN/18/000021 2018-02-07 11:19:18 IP/18/000022 Mrs VIDYA   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:19:18 000012 AEH
22 BN/18/000022 2018-02-07 11:19:27 IP/18/000025 Mr GAGANRAM   B 2018-02-06 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-07 11:19:27 000012 AEH
23 BN/18/000023 2018-02-07 11:19:55 IP/18/000031 Mrs SHYAMA DEVI B 2018-02-06 Y Y Dr Upendra Singh 7550.00 7550.00 7550.00 0.00 7550.00 0.00 NULL2018-02-07 11:19:55 000012 AEH
24 BN/18/000024 2018-02-09 11:42:20 IP/18/000032 Smt KALPA   B 2018-02-07 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-09 11:42:20 000002 AEH
25 BN/18/000025 2018-02-09 11:43:16 IP/18/000038 Smt KAILASHA   B 2018-02-07 Y Y Dr Upendra Singh 0.00 0.00 0.00 0.00 0.00 0.00 NULL2018-02-09 11:43:16 000002 AEH