将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 49707 行, 查询花费 0.0015 秒。)
SELECT * FROM `CompanyMaster`
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 fin_codescrip_codescrip_namescrip_groupco_nameind_codeindustryhse_codehousesymbolseriesisinco_short_nameres_formatfin_formatchairmanmdirco_secinc_monthinc_yearfvstatussub_listingbse_scrip_idsec_tokencinbse_sub_listnse_sub_listflag
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100002
100002 500002 ABB LTD. A ABB India Ltd. 39 Electric Equipment 342 ABB India - MNC ABB EQ INE117A01022 ABB India MAN MAN Sanjeev Sharma Trivikram Guda 24-12 1949 2.00 Active Active ABB 13 L32202KA1949PLC032923 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100003
100003 500003 AEGISLOG A Aegis Logistics Ltd. 68 Logistics 348 Aegis Logistics - MNC AEGISLOG EQ INE208C01025 Aegis Logistics MAN SER Raj K Chandaria Raj K Chandaria Monica Gandhi 30-06 1956 1.00 Active Active AEGISLOG 40 L63090GJ1956PLC001032 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100005
100005 500005 AKARLAMIN XD Akar Laminators Ltd. 76 Packaging 206 Private AKARLAMIN EQ INE984C01013 Akar Laminators MAN MAN Vinod Sheth Vinod Sheth - 1989 10.00 Delisted Delisted AKARLAMIN 61 L20211GJ1989PLC012415 Delisted Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100008
100008 500008 ARE&M A Amara Raja Energy & Mobility Ltd. 17 Batteries 357 Amara Raja ARE&M EQ INE885A01032 Amara Raja Energy MAN MAN Jayadev Galla Jayadev Galla Vikas Sabharwal 13-02 1985 1.00 Active Active ARE&M 100 L31402AP1985PLC005305 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100009
100009 500009 A.SARABHAI X Ambalal Sarabhai Enterprises Ltd. 80 Pharmaceuticals & Drugs 249 Sarabhai AMBASARABH EQ INE432A01017 Ambalal Sarabhai Ent MAN MAN Kartikeya V Sarabhai Mohal K Sarabhai Disha Mahesh Punjani 05-06 1978 10.00 Active Active AMBALALSA 106 L52100GJ1978PLC003159 Active InActive A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100010
100010 500010 HDFC A Housing Development Finance Corporation Ltd. 48 Finance - Housing 336 HDFC HDFC EQ INE001A01036 HDFC FIN FIN Deepak S Parekh Renu Sud Karnad Ajay Agarwal 17-10 1977 2.00 Active Active HDFC 1330 L70100MH1977PLC019916 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100012
100012 500012 ANDHRA PETRO X Andhra Petrochemicals Ltd. 25 Chemicals 206 Private ANDHRAPET EQ INE714B01016 Andhra Petrochem MAN MAN Pamidi Kotaiah P Narendranath Chowdary G Adinarayana 18-04 1984 10.00 Active Active ANDHRAPET 133 L23209AP1984PLC004635 Active InActive A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100013
100013 500013 ANSAL INFRAS Z Ansal Properties & Infrastructure Ltd. 29 Construction - Real Estate 9 Ansal ANSALAPI BZ INE436A01026 Ansal Prop. & Infra MAN RLT Pranav Ansal Abdul Sami 30-06 1967 5.00 Active Active ANSALAPI 19677 L45101DL1967PLC004759 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100014
100014 500014 UTIQUE X Utique Enterprises Ltd. 49 Finance - Investment 206 Private APPLEIND EQ INE096A01010 Utique Enterprises MAN FIN P B Deshpande 15-10 1985 10.00 Active Active UTIQUE 172 L65910MH1985PLC037767 Active InActive A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100016
100016 500016 ARUNAHTEL X Aruna Hotels Ltd. 60 Hotel  Resort & Restaurants 206 Private ARUNASUGAR EQ INE957C01019 Aruna Hotel MAN HTL Radhaswamy Venkateswaran N Sornalatha - 1960 10.00 Active Active ARUNAHTEL 190 L15421TN1960PLC004255 Active InActive A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100019
100019 500019 BANK OF RAJ. B The Bank Of Rajasthan Ltd. 15 Bank - Private 142 Krishna BANKRAJAS EQ INE320A01014 Bank of Raj BNK BNK G Padmanabhan R K Agarwal 08-05 1943 10.00 Delisted Delisted BOR 0 L65191RJ1943PLC000135 Delisted Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100020
100020 500020 BOM DYEING A Bombay Dyeing And Manufacturing Company Ltd. 98 Textile 321 Wadia BOMDYEING EQ INE032A01023 Bombay Dyeing Mfg. MAN MAN Nusli N Wadia Sanjive Arora 23-08 1879 2.00 Active Active BOMDYEING 513 L17120MH1879PLC000037 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100023
100023 500023 ASIANHOTNR T Asian Hotels (North) Ltd. 60 Hotel  Resort & Restaurants 339 MNC ASIANHOTNR BE INE363A01022 Asian Hotels (North) MAN HTL Preeti Gandhi Tarun Srivastava 13-11 1980 10.00 Active Active ASIANHOTNR 18425 L55101DL1980PLC011037 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100024
100024 500024 ASSAMCO T Assam Company India Ltd. 95 Tea/Coffee 161 Mehta Mahendra ASSAMCO BE INE442A01024 Assam Company India MAN MAN Bavaguthu Raghurama Shetty Beas Moitra 15-03 1977 1.00 Delisted Delisted ASSAMCO 0 L01132AS1977PLC001685 Delisted Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100025
100025 500025 ASSAMBROOK X Assambrook Ltd. 95 Tea/Coffee 206 Private INE353C01011 Assambrook MAN MAN Sanjoy Ghosh 08-08 1947 10.00 Delisted Delisted ASSAMBR 0 L70109AS1947PLC009386 Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100027
100027 500027 ATUL LTD. A Atul Ltd. 25 Chemicals 151 Lalbhai ATUL EQ INE100A01010 Atul MAN MAN Sunil Lalbhai Sunil Lalbhai Lalit Patni 11-12 1975 10.00 Active Active ATUL 263 L99999GJ1975PLC002859 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100028
100028 500028 ATV PROJECTS X ATV Projects India Ltd. 44 Engineering - Industrial Equipments 206 Private ATVPROJ BE INE447A01015 ATV Projects India MAN MAN M V Chaturvedi 26-02 1987 10.00 Active Active ATVPR 0 L99999MH1987PLC042719 Active InActive A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100029
100029 500029 AUTOLITE(I) Z Autolite (India) Ltd. 10 Auto Ancillary 18 Autopal AUTOLITIND BZ INE448A01013 Autolite India MAN MAN 30-06 1977 10.00 Delisted Delisted AUTOLITIND 10061 L31506RJ1977PLC001738 Delisted Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100030
100030 500030 AUTORID.FIN Z Autoriders Finance Ltd. 49 Finance - Investment 19 Autoriders AUTORIDFIN EQ INE450A01019 Autoriders Fin MAN FIN Prabhakar Chavan 21-02 1985 10.00 Delisted Delisted AUTORIDFIN 290 L51900MH1985PLC035433 Delisted Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100031
100031 500031 BAJAJ ELECT. A Bajaj Electricals Ltd. 30 Consumer Durables - Domestic Appliances 22 Bajaj BAJAJELEC EQ INE193E01025 Bajaj Electricals MAN MAN Shekhar Bajaj Prashant Dalvi 14-07 1938 2.00 Active Active BAJAJELEC 15034 L31500MH1938PLC009887 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100032
100032 500032 BAJAJHIND A Bajaj Hindusthan Sugar Ltd. 94 Sugar 22 Bajaj BAJAJHIND EQ INE306A01021 Bajaj Hindusthan Sug MAN MAN Kushagra Bajaj Ajay Kumar Sharma Kausik Adhikari 24-11 1931 1.00 Active Active BAJAJHIND 308 L15420MH1931PLC001797 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100033
100033 500033 FORCE MOTR A Force Motors Ltd. 14 Automobiles-Trucks/Lcv 767 AbhayKumar Firodia FORCEMOT EQ INE451A01017 Force Motors MAN MAN Abhaykumar Navalmal Firodia Prasan Abhaykumar Firodia Rohan Sampat 08-09 1958 10.00 Active Active FORCEMOT 11573 L34102PN1958PLC011172 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100034
100034 500034 BAJFINANCE A Bajaj Finance Ltd. 50 Finance - NBFC 22 Bajaj BAJFINANCE EQ INE296A01024 Bajaj Finance FIN FIN Sanjiv Bajaj Rajeev Jain R Vijay 25-03 1987 2.00 Active Active BAJFINANCE 317 L65910MH1987PLC042961 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100035
100035 500035 BALAJI DISTL T Balaji Distilleries Ltd. (Merged) 19 Breweries & Distilleries 25 Balaji BALAJIDIST BE INE453A01013 Balaji Distilleries MAN MAN R Raghuram G Sriraman - 1993 10.00 Merged Merged BALAJIDI             8535 L15520TN1983PLC055365 Merged Merged A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 100036
100036 500036 BALAJIIND X Balaji Industrial Corporation Ltd. 92 Steel & Iron Products 25 Balaji BALAJIIND EQ INE455A01018 Balaj Inds Corp MAN MAN - 1984 10.00 Delisted Delisted BALAJIIND 332 L74999AP1984PLC015354 Delisted Delisted A
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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