将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 6246 行, 查询花费 0.0084 秒。) [sectorname: AEROSPACE & DEFENCE... - AEROSPACE & DEFENCE...]
SELECT * FROM `CompanyMaster` ORDER BY `sectorname`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 co_codebsecodensesymbolco_namelnamesectorcodesectorname 递增 递减 1mcappeepsfvbsegroupBSEListedNSEListedPE_conlatbvlatepsEV_EBIDTAEV_SalesDivYield
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 18203
18203 590041 KAVVERITEL Kavveri Defence Kavveri Defence & Wireless Technologies Ltd 00000085 Aerospace & Defence 153.100 92.790 0.480 10.000 T Y Y 61.010 20.628 0.480 0.000 0.000 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 2334
2334 523610 ITI ITI ITI Ltd 00000085 Aerospace & Defence 24665.971 0.000 0.000 10.000 A Y Y 0.000 16.529 0.000 0.000 19.994 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 39972
39972 543428 DATAPATTNS Data Pattern Data Patterns (India) Ltd 00000085 Aerospace & Defence 12934.260 72.330 31.940 2.000 A Y Y 0.000 241.072 31.940 49.210 25.337 0.280
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 25386
25386 532725 SOLARINDS Solar Industries Solar Industries India Ltd 00000085 Aerospace & Defence 118025.273 156.220 83.490 2.000 A Y Y 105.170 292.910 83.490 89.310 21.454 0.070
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 305
305 500306 JKSYNTHETC Jaykay Enter. Jaykay Enterprises Ltd 00000085 Aerospace & Defence 1860.710 94.730 1.680 1.000 B Y N 121.490 25.488 1.680 49.470 356.327 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 14133
14133 541195 MIDHANI Mishra Dhatu Nig Mishra Dhatu Nigam Ltd 00000085 Aerospace & Defence 5770.070 57.570 5.350 10.000 A Y Y 57.140 71.964 5.350 34.640 7.266 0.460
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 92237
92237 544061 AZAD Azad Engineering Azad Engineering Ltd 00000085 Aerospace & Defence 10023.410 129.450 11.990 2.000 A Y Y 130.210 214.146 11.990 54.160 23.614 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 93016
93016 93016 C2C C2C Advanced C2C Advanced Systems Ltd 00000085 Aerospace & Defence 689.780 55.640 7.450 10.000 NULL N Y 0.000 105.477 7.450 0.000 0.000 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 78688
78688 543932 IDEAFORGE Ideaforge Tech Ideaforge Technology Ltd 00000085 Aerospace & Defence 1642.770 0.000 0.000 10.000 A Y Y 0.000 152.472 0.000 29.820 8.501 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 4472
4472 532493 ASTRAMICRO Astra Microwave Astra Microwave Products Ltd 00000085 Aerospace & Defence 7881.860 66.410 12.500 2.000 A Y Y 58.630 103.179 12.500 27.920 6.366 0.240
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 5762
5762 540678 COCHINSHIP Cochin Shipyard Cochin Shipyard Ltd 00000085 Aerospace & Defence 40250.039 48.910 31.280 5.000 A Y Y 50.380 201.999 31.280 16.470 5.387 0.640
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 17540
17540 541143 BDL Bharat Dynamics Bharat Dynamics Ltd 00000085 Aerospace & Defence 54511.512 96.380 15.430 5.000 A Y Y 0.000 101.813 15.430 31.010 11.766 0.350
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 76686
76686 543650 DCXINDIA DCX Systems DCX Systems Ltd 00000085 Aerospace & Defence 3166.160 60.480 4.700 2.000 A Y Y 61.930 101.762 4.700 23.310 1.904 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 20881
20881 532406 AVANTEL Avantel Avantel Ltd 00000085 Aerospace & Defence 2813.240 46.920 2.450 2.000 A Y Y 49.760 10.134 2.450 28.160 9.630 0.170
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 1181
1181 523606 NULL Sika Interplant Sika Interplant Systems Ltd 00000085 Aerospace & Defence 1445.160 60.110 11.340 2.000 B Y N 58.610 51.885 11.340 23.440 5.866 0.290
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 12963
12963 543237 MAZDOCK Mazagon Dock Mazagon Dock Shipbuilders Ltd 00000085 Aerospace & Defence 120905.094 45.590 65.750 5.000 A Y Y 43.950 162.473 65.750 9.130 2.464 0.460
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 3755
3755 522229 TANEJAERO Taneja Aerospace Taneja Aerospace & Aviation Ltd 00000085 Aerospace & Defence 724.730 50.040 5.680 5.000 T Y N 50.040 54.118 5.680 49.670 32.242 1.410
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 13229
13229 542011 GRSE Garden Reach Sh. Garden Reach Shipbuilders & Engineers Ltd 00000085 Aerospace & Defence 21561.551 54.620 34.460 10.000 A Y Y 0.000 160.817 34.460 9.550 1.422 0.500
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 75439
75439 543367 PARAS Paras Defence Paras Defence and Space Technologies Ltd 00000085 Aerospace & Defence 5430.780 83.460 16.150 10.000 A Y Y 85.570 149.312 16.150 38.310 10.383 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 93631
93631 544322 UNIMECH Unimech Aero. Unimech Aerospace and Manufacturing Ltd 00000085 Aerospace & Defence 4640.180 322.400 2.830 5.000 B Y Y 62.710 103.521 2.830 0.000 0.000 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 34242
34242 543270 MTARTECH MTAR Technologie MTAR Technologies Ltd 00000085 Aerospace & Defence 4387.390 98.100 14.540 10.000 A Y Y 99.610 227.731 14.540 45.060 9.169 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 76486
76486 535444 KRISHNADEF Krishna Defence Krishna Defence & Allied Industries Ltd 00000085 Aerospace & Defence 1043.840 107.120 7.110 10.000 NULL N Y 106.820 71.981 7.110 26.330 4.220 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 71623
71623 540879 APOLLO Apollo Micro Sys Apollo Micro Systems Ltd 00000085 Aerospace & Defence 3567.540 63.610 1.830 1.000 B Y Y 64.310 18.793 1.830 33.270 7.744 0.040
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 78289
78289 543920 NULL CFF Fluid CFF Fluid Control Ltd 00000085 Aerospace & Defence 998.830 41.870 12.250 10.000 MT Y N 0.000 75.913 12.250 25.950 7.507 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 21203
21203 533339 ZENTEC Zen Technologies Zen Technologies Ltd 00000085 Aerospace & Defence 12543.590 59.910 23.190 1.000 A Y Y 59.070 173.294 23.190 40.740 18.327 0.070
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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