Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sams »Table: pension_details
Page-related settingsClick 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.

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 (447 total, Query took 0.0676 seconds.)
SELECT * FROM `pension_details`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsidpen_idemp_idpensioner_nameretirement_designationpensionpension_typenomineerelationshippensioner_addressdate_of_birthdate_of_joiningdate_of_retirementdodbank_account_numberbank_namebank_branchbank_ifscpanaadharpen_categorycpclast_pay_drawnpay_levelbasic_pensioncommutation_portionbasic_after_commutationqualified_servicedod_dedearness_relieffr_erdocfamily_pension_normal_ratenr_dategratuityel_encashmenthpl_encashmentcommutation_valuerecovery_amountfamily_pension_enhanced_ratepay5pay67th_paypay820%_quantum_pension_upto30%_quantum_pension_upto40%_quantum_pension_upto50%_quantum_pension_upto100%_quantum_pension_uptopp_or_nospecial_remarks
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 1
1 P002 10002 SRINIVASA RAO A Dr. PROFESSOR SUPERANNUATION SELF 101 A BELREVUE GARDEN II, PADMA RAO NAGAR, SECENDR... 15-02-1935 12-02-1995 415693685 INDIAN BANK PONDICHERRY UNIVERSITY IDIB000P152 AADPR2575G 450441091134 Teaching 60909 0 60909 0 60909 42887 60909 February 2015 February 2020 February 2025 February 2030 February 2035
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 2
2 P003 10003 VISWANATHAN A VISWANATHAN A SUPERANNUATION SELF Smt. UMA MAHESWARI WIFE C 15 RACE VIEW APPARTMENT, CART TRACK ROAD, VELLAC... 15-06-1935 01-07-1988 30-06-1995 413240558 INDIAN BANK PU IDIB000P152 ABQPR9542H 583061353114 Non-Teaching 23264 2675 2000-60-2300-EP-75-3200-100-3500 23264 0 23264 17Y, 7M,25D 38596 33986 84191 442X12X0.81 = 52033 10862 10862 23264 June 2015 June 2020 June 2025 June 2030 June 2035 37, DT 23.07.1999 REVISED RETIRE. GRATUITY
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 3
3 P004 10004 PANDURANGAN A Dr. PROFESSOR SUPERANNUATION SELF THIRUVARANGAM WIFE 30, 19th CROSS, AVVAI NAGAR, LAWSPET, PONDICHERRY,... 10-06-1935 01-12-1986 30-06-1995 491400225 INDIAN BANK LAWSPET IDIB000P152 AAEPP8604M 568780489463 Teaching 60909 16400 16400-450-20900-500- 2400 60909 0 60909 28440 152846 1111010 =M 943 X 12 X 9.8 28440 60909 June 2015 June 2020 June 2025 June 2030 June 2035 26 , DT 21.12.95 PENSION REVISED
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 4
4 P006 10006 THIYAGARAJAN M.T. Dr PROFESSOR SUPERANNUATION SELF T. MAHALAKSHMI WIFE 54/19 FIRST CROSS, BHARATHI COLONY PEELAMEDU, COIM... 26-10-1936 17-11-1986 31-10-1996 470961434 INDIAN BANK PU IDIB000P152 AAYPT7538G 294445015876 Teaching 7698 6900 7698 0 7698 11Y AND 26D 35370 2995 62040 45087 = 383 X 12X 9.81 2995 7698 October 2016 October 2021 October 2026 October 2031 October 2036 275, DT 31.10.1996 COMP. 80 AGE
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 5
5 P007 10007 RAMACHANDRA NAIR AG Dr. PROFESSOR SUPERANNUATION SELF NIRMALA WIFE LAVANYA 272 HIG, HOUSE, AMBADKAR ST. AIRPORT ROAD,... 22-11-1937 05-10-1960 30-11-1997 491352350 STATE BANK OF INDIA JIPMERCAMPUS AACPR8102L 423548868614 Teaching 60909 5700 60909 0 60909 37Y, 1M, 27D 28440 339339 82264 428500 = 3640 X 12 X 9.81 28440 60909 November 2017 November 2022 November 2027 November 2032 November 2037 71, DT 29.10.2002
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 6
6 P008 10008 NATARAJAN V Dr. DEPUTY REGISTRAR SUPERANNUATION SELF N. MANJULA@ RAJALAKSHMI WIFE 3 B DIAMOND COLONY, VEERAPATHRAN NAGAR, MEEDAVAKKA... 15-07-1938 30-12-1985 30-11-1997 450623034 INDIAN BANK PU IDIB000P152 AADPN0925A Non-Teaching 59239 14100 59239 0 59239 35Y,3M,10D 23050 14-07-2005 283833 30964 329993 23050 59239 July 2018 July 2023 July 2028 July 2033 July 2038 84, DT 02.08.1999 REVISED ORDER,  LIBRARY DUES
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 7
7 P009 10009 MATHEW K S Dr. MATHEW K S Dr. SUPERANNUATION SELF "KUZHIPPALLIL", KURUMULLOOR P.O, KOTTAYAM DIST, KE... 08-06-1939 28-12-1987 30-06-2001 876445308 INDIAN BANK PU IDIB000P152 AALPS5073Q 900588150331 Teaching 60909 20450 60909 0 60909 13Y,06M,04M 37073 13220 197394 256823 = 2339 X 9.15 X 12 13220 60909 June 2019 June 2024 June 2029 June 2034 June 2039 136, DT 19.03.2004 REVISED ORDER
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 8
8 P010 10010 MARUTHANAYAGAM P.Dr. MARUTHANAYAGAM P.Dr. SUPERANNUATION SELF M. KAMALA WIFE 15, KASTHURI BAI NAGAR, THATTANCHAVADI, PONDICHERR... 03-06-1939 01-12-1986 30-06-2001 413241574 INDIAN BANK PU IDIB000P152 AEVPM6984Q Teaching 60909 20450 60909 0 60909 14Y, 7M 37073 38140 6135 03-06-2004 209051 195554 = 1781 X 12 X 9.15 6135 10414 60909 June 2019 June 2024 June 2029 June 2034 June 2039 07, DT 18.07.2001 PROVISIONAL (PENSION)
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 9
9 P011 10011 DATCHANAMURTHY T DY. CONTROLLER OF EXAMINATIONS SUPERANNUATION SELF PLOT NO.1 MOH FAROOK ST, MUNICIPAL ROAD, REDDIARPA... 17-10-1941 11-06-1988 31-10-2001 413240069 INDIAN BANK PU IDIB000P152 934947444533 Non-Teaching 16759 14100 16759 0 16759 138004 47705 16759 October 2021 October 2026 October 2031 October 2036 October 2041
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 10
10 P012 10012 KRISHNARAJ S. DEPUTY REGISTRAR SUPERANNUATION DEPUTY REGISTRAR JEGAJOTHI WIFE 6, 2ND CROSS, RAJA RAJESWARAI NAGAR, PONDICHERRY, ... 12-11-1941 11-06-1986 30-11-2001 413244687 INDIAN BANK PU IDIB000P152 AAKPK1196R 420980026027 Non-Teaching 38021 13260 38021 0 38021 37226 14794 317246 192270 303294 6250 14794 38021 November 2021 November 2026 November 2031 November 2036 November 2041 53, DT 09.05.2002 PU STAFF CO-OP.
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 11
11 P014 10014 JOTHILINGAM P Dr. PROFESSOR SUPERANNUATION SELF J.LALITHA WIFE NO. 42, SECOND CROSS ST, KURUNGI NAGAR, PONDICHERR... 01-06-1940 11-12-1986 31-05-2002 413243479 INDIAN BANK PU IDIB000P152 AAHPJ1809P 552967493592 Teaching 60909 20900 60909 0 60909 15Y,   6M 37408 39234 6270 31-05-2007 241343 129754 343894 = 3132 X 9.15 X12 7832 17701 60909 June 2020 June 2025 June 2030 June 2035 June 2040 61, DT 01.12.2004 COMMUTED PORTION RESTORED
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 12
12 P016 10016 GABRIEL S Dr. PROFESSOR SUPERANNUATION SELF JAMUNARANI..S WIFE 55, SANTHOSH BORA  NAGAR, KARANAI PUDUCHERRY ROAD,... 12-10-1940 31-10-2002 64942200019111 INDIAN BANK PU IDIB000P152 AKSPS5403P 772752020903 Teaching 60909 20900 60909 0 60909 26 1/2 Y 37561 39366 6270 12-10-2007 350000 524172 8248 8248 39266 60909 October 2020 October 2025 October 2030 October 2035 October 2040 62 DT 23.01.2003
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 13
13 P018 10018 DEVI RAMAMURTHY MESS HELPER FAMILY PENSIONER PEON W/O LATE RAMAURTHY WIFE No: 2, GANDHI STREET,, MANALI, CHENNAI, TAMIL NADU... DEVI.R 413246855 INDIAN BANK PU IDIB000P152 BCYPD6684C 235623908945 Non-Teaching 9000 810 2550-55-2660-60-3200 9000 0 9000 14-08-1991 3500 9720 35000 9000 May 2047 May 2052 May 2057 May 2062 May 2067 166,DT 22.02.2000 CYCLE ADV
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 14
14 P019 10019 VASANTHA KRISHNAN PROFESSOR FAMILY PENSIONER W/O KRISHNAN VASANTHA KRISHNAN 2/S-4/VIRUPAKSHA FLATS, 16 TH STREET NANGANALLUR, ... 07-08-1943 08-02-1992 453935223 INDIAN BANK Pondicherry University AJRPV2123P 503114120573 Teaching 20910 0 20910 0 20910 20910 August 2023 August 2028 August 2033 August 2038 August 2043
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 15
15 P020 10020 ELLAMMAL RAJENDIRAN DRIVER LEVEL - I FAMILY PENSIONER W/O RAJENDIRAN ELLAMMAL RAJENDIRAN WIFE No:20, NORTH CAR STREET,, OPP to Police Station, T... 10-02-1962 413248230 INDIAN BANK PU IDIB000P152 Non-Teaching 9000 9480 5200+20200+GP 1900 9000 0 9000 9000 February 2042 February 2047 February 2052 February 2057 February 2062
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 16
16 P021 10021 ARAVALLI SUBRAMANIYAN DRIVER LEVEL - I FAMILY PENSIONER W/O SUBRAMANIYAN(D) ARAVALLI SUBRAMANIYAN 11, SANDARPALYAM, CUDDLORE ROAD, MURUNGAPAKKAM, PU... 26-01-1962 14-01-1997 413249471 INDIAN BANK PU IDIB000P152 BPQPA3986M 661602982067 Non-Teaching 0 0 9000 0 9000 14-01-1997 3500 45360 3500 9000 January 2042 January 2047 January 2052 January 2057 January 2062 156, DT 02.02.2000 FEST.ADVAN
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 17
17 P022 10022 CHANDRAMALA RAMACHANDRAN PROFESSOR FAMILY PENSIONER W/O Dr. RAMACHANDRAN (LATE) RAMACHANDRAN 121A/34, PIDARI, SOUTH STREET,, SIRKALI, TAMILNADU... 10-02-1962 508469737 INDIAN BANK PU IDIB000P152 Teaching 19129 10975 10000-325-15200 19129 0 19129 6 YEARS 24-08-1998 7443 160680 7443 19129 February 2042 February 2047 February 2052 February 2057 February 2062 266, DT 02.02.2000
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 18
18 P023 10023 NAVANEETHAM KRISHNASAMY WATCHMAN FAMILY PENSIONER W/O KRISHNASAMY NAVANEETHAM W/O, V. KRISHNASAM 33, NETHAJI STREET, CHINNAKALAPET, PUDUCHERRY, PUD... 30-06-1973 16-11-1999 413253329 INDIAN BANK PU IDIB000P152 BXGPN1140N 213312240691 Non-Teaching 9000 3350 3050+75+3950+4590 9000 0 9000 16-11-1999 36495 3500 55080 15759 48850 3500 8365 9000 June 2053 June 2058 June 2063 June 2068 June 2073 180, DT 27.03.2000 IMMEDI RELIEF, CRED SOC.
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 19
19 P024 10024 GOWRI BALASUBRAMANIAN READER FAMILY PENSIONER W/O BALASUBRAMANIAN BALASUBRAMANIAN 5, SAMIPILLAI THOTTAM, MANI ROAD, LAWSPET, PUDUCHE... 05-12-1999 413253523 INDIAN BANK PU IDIB000P152 AIPPB6952K 870243467065 Teaching 32524 4075 3700-125-4950-150-5700 32524 0 32524 05-12-1999 36500 39056 49860 06-12-2006 350000 100184 83100 32524
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 20
20 P025 10025 RAJALAKSHMI MUTHUKUMARAN HORTICULTURE ATTENDANT FAMILY PENSIONER W/O MUTHUKUMARAN RAJALAKSHM 33, VANNIAR STREET, VATHIKUPPAM, PONDICHERRY, PUDU... 02-03-1970 09-02-2020 413254163 INDIAN BANK PU IDIB000P152 CGYPR7477Q 726670269323 Non-Teaching 9000 2780 2550-55-2660-60-3200 9000 0 9000 9000 March 2050 March 2055 March 2060 March 2065 March 2070
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 21
21 P026 10026 LATHA COULASEKARAN WATCHMAN FAMILY PENSIONER W/O COULASEKARAN LATHA W/O COULASEKARAN 18,THOWPATHI AMMAN KOIL STREET, PILLAICHAVADY, PON... 22-05-1971 14-06-2001 413244440 INDIAN BANK PU IDIB000P152 AGKPL8983B 619783858493 Non-Teaching 9000 2900 2550-55-2660-60-3200 9000 0 9000 14-06-2001 37057 3500 49764 49764 3500 9000 May 2051 May 2056 May 2061 May 2066 May 2071 150, dt 17.09.2001 CRED. SOCIETY, FESTIVAL ADV, CYCLE ADVA
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 22
22 P027 10027 VALARMATHI THIRUNAVUKARASSU WATCHMAN FAMILY PENSIONER W/O THIRUNAVUCKARASSU VALARMATHI  W/O THIRUNAVUKARAS NO.70, ECR ROAD, PERIYAKALAPET, PONDICHERRY, PUDUC... 10-04-1975 31-10-2002 413257801 INDIAN BANK PU IDIB000P152 ALXPV6375P 756958956730 Non-Teaching 9000 2960 2550-55-2660-60-3200 9000 0 9000 31-10-2002 37563 3500 21703 51 83376 3500 9000 April 2055 April 2060 April 2065 April 2070 April 2075 92, DT 12.03.2003 FESTIVE, CYCLE , SOCIET, IMMED RELIEF
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 23
23 P028 10028 FATHIMA MARY ANGALAN PEON FAMILY PENSIONER W/O ANGALAN FATHIMA MARY W/O LATE    R.  A No.9, North pet, Thengaithittu, Mudaliarpet  puduc... 16-02-1952 02-04-2002 756013941 INDIAN BANK PU IDIB000P152 666695180230 Non-Teaching 9000 3425 3050+75+3950+4590 9000 0 9000 04-02-2002 37316 3500 61236 1155354 3500 9000 February 2032 February 2037 February 2042 February 2047 February 2052 31, DT 27.08.2002 STAFF SOCIETY, CYCLONE ADV,IMREL, EOL
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 24
24 P029 10029 VILMANI S ASSISTANT  ENGINEER SUPERANNUATION SELF SREE RANDJINI WIFE PLOT NO 43/32, 14TH CROSS, 6' EXTN. KRISHNA NAGAR,... 15-06-1943 01-08-1998 30-06-2003 413242307 INDIAN BANK PU IDIB000P152 BJCPV8397R 763521652486 Non-Teaching 34151 12175 8000-275-13500 34151 0 34151 37803 10937 300700 45105 276760 13288 34151 June 2023 June 2028 June 2033 June 2038 June 2043 31-32, DT 23.06.04 REVISED ORDER
Edit EditCopy CopyDelete Delete
DELETE FROM `pension_details` WHERE `pension_details`.`id` = 25
25 P031 10031 PADMA RAJAGOPALAN PROFESSOR FAMILY PENSIONER WIFE PADMA W/O LATE DR. RAJAGOPLAN 20/39  CAR STREET, TRIPLICANE, TAMIL NADU, CHENNAI... 06-07-1945 20-04-2003 742911475 INDIAN BANK PU IDIB000P152 AIWPR5270P 745189135852 Teaching 36420 20900 36420 0 36420 37731 350000 64790 271060.26 14171 36420 July 2025 July 2030 July 2035 July 2040 July 2045 99, DT 12.08.2003 ADVA.1&2,PC INT, LIBR.BOOK..,
With selected: With selected:

|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.