将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenAccordComapnyData »表: CompanyMaster
页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 49707 行, 查询花费 0.0458 秒。) [inc_year: ... - ...]
SELECT * FROM `CompanyMaster` ORDER BY `inc_year`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 fin_codescrip_codescrip_namescrip_groupco_nameind_codeindustryhse_codehousesymbolseriesisinco_short_nameres_formatfin_formatchairmanmdirco_secinc_monthinc_year 递增 递减 1fvstatussub_listingbse_scrip_idsec_tokencinbse_sub_listnse_sub_listflag
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 267008
267008 0 ICICI Prudential Fixed Maturity Plan - Series 74 -... 113 Unspecified 206 Private IPRU2406 MF INF109KA1WM1 IPRU2406 - 10.00 NonEquity Active 4096 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 267264
267264 950446 1175CREDILA F Credila Financial Services Pvt. Ltd. - (1175CREDIL... 113 Unspecified 206 Private INE539K08112 1175CREDILA - 1000000.00 NonEquity Active 1175CREDILA 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 267520
267520 950529 925KMPL15 F Kotak Mahindra Prime Ltd. - (925KMPL15) 113 Unspecified 206 Private INE916DA7EK5 925KMPL15 - 1000000.00 NonEquity Active 925KMPL15 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 270336
270336 0 Sundaram Fixed Term Plan - DV  - (RLDVDG) 113 Unspecified 206 Private RLDVDG MF INF903J01T54 RLDVDG - 10.00 NonEquity Active 4823 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 271360
271360 935226 0MFL2016D F Manappuram Finance Ltd. - (0MFL2016D) 113 Unspecified 206 Private INE522D07800 0MFL2016D - 1000.00 NonEquity Active 0MFL2016D 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 272128
272128 951315 9SEL2019C F Sadbhav Engineering Ltd. - (9SEL2019C) 113 Unspecified 206 Private INE226H07064 9SEL2019C - 1000000.00 NonEquity Active 9SEL2019C 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 272384
272384 538839 IPRU2571 F ICICI Prudential Growth Fund - Series 5 (Regular P... 113 Unspecified 206 Private INF109KA12K5 IPRU2571 - 10.00 NonEquity Active IPRU2571 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 272896
272896 951594 879MMFSL25 F Mahindra & Mahindra Financial Services Ltd. - (879... 113 Unspecified 206 Private INE774D07KW6 879MMFSL25 - 1000000.00 NonEquity Active 879MMFSL25 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 273152
273152 951678 820PGCIL30 F Power Grid Corporation of India Ltd. - (820PGCIL30... 113 Unspecified 206 Private INE752E07MH7 820PGCIL30 - 1000000.00 NonEquity Active 820PGCIL30 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274176
274176 537716 TFM46PD F TATA Fixed Maturity Plan Series 46 Scheme P - (TFM... 113 Unspecified 206 Private INF277K01O62 TFM46PD - 10.00 NonEquity Active TFM46PD 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274432
274432 0 Canara Robeco Capital Protection Oriented Fund - S... 113 Unspecified 206 Private CRMFCP5DG MF INF760K01HU2 CRMFCP5DG - 10.00 NonEquity Active 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274688
274688 34 S&P Ex BSEIT 147 Index 0 S&P Ex BSEIT - 0.00 Index Active 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274944
274944 951990 105AAL2020 F Amtek Auto Ltd. - (105AAL2020) 113 Unspecified 206 Private INE130C07275 105AAL2020 - 1000000.00 NonEquity Active 105AAL2020 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 275968
275968 538255 RFHXXVI17G F Reliance FHF XXVI - Series 17 - (RFHXXVI17G) 113 Unspecified 206 Private INF204KA1X76 RFHXXVI17G - 10.00 NonEquity Active RFHXXVI17G 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 276224
276224 537176 H504D29RD1 F HDFC FMP 504D December 2013 (1) – Series 29 - (H... 113 Unspecified 206 Private H50429DRD1 MF INF179KB1750 H504D29RD1 - 10.00 NonEquity Active H504D29RD1 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 276480
276480 537302 BSLFTPJRDQ F Birla Sun Life FTP Series JR (1162 Days) - (BSLFTP... 113 Unspecified 206 Private INF209KA13D6 BSLFTPJRDQ - 10.00 NonEquity Active BSLFTPJRDQ 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 276736
276736 539183 H1127M33DQ F HDFC FMP 1127D MAY 2015 (1) - SERIES 33 - DIRECT O... 113 Unspecified 206 Private H1127M33DQ MF INF179KB1DF9 H1127M33DQ - 10.00 NonEquity Active H1127M33DQ 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 276992
276992 538509 H370J31DG2 F HDFC MF FMP 370D JUNE 2014 (2) Series 31 - (H370J3... 113 Unspecified 206 Private H37031JDG2 MF INF179KB1ET8 H370J31DG2 - 10.00 NonEquity Active H370J31DG2 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 277248
277248 952395 0BFL17Y F Bajaj Finance Ltd. - (0BFL17Y) 113 Unspecified 206 Private INE296A07HD2 0BFL17Y - 1000000.00 NonEquity Active 0BFL17Y 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 277760
277760 952435 ZCECSL17 F Edelweiss Commodities Services Ltd. - (ZCECSL17) 113 Unspecified 206 Private INE657N07035 ZCECSL17 - 1000000.00 NonEquity Active ZCECSL17 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 278016
278016 952507 91794SCUF17 F Shriram City Union Finance Ltd. - (91794SCUF17) 113 Unspecified 206 Private INE722A07661 91794SCUF17 - 1000000.00 NonEquity Active 91794SCUF17 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 278272
278272 952620 1352AMPL18 F Asirvad Microfinance Pvt Ltd. - (1352AMPL18) 113 Unspecified 206 Private INE516Q07093 1352AMPL18 - 1000000.00 NonEquity Active 1352AMPL18 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 278784
278784 961720 IDFCBD1SR2 F IDFC Bank Ltd. - NA 113 Unspecified 206 Private IDFCFIRSTB NA INE092T08CL7 IDFCBANK-NA - 5000.00 NonEquity Active IDFCBD1SR2 10817 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 279296
279296 953078 ZCBFL2019 F Bajaj Finance Ltd. - (ZCBFL2019) 113 Unspecified 206 Private INE296A07IM1 ZCBFL2019 - 1000000.00 NonEquity Active ZCBFL2019 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 279552
279552 539567 RXXIX20Z F Reliance Fixed Horizon Fund XXIX Series -  20 Dire... 113 Unspecified 206 Private INF204KA17T4 RXXIX20Z - 10.00 NonEquity Active RXXIX20Z 0 A
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

将此 SQL 查询加为书签 将此 SQL 查询加为书签