• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 6246 行, 查询花费 0.0012 秒。)
SELECT * FROM `CompanyMaster`
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 co_codebsecodensesymbolco_namelnamesectorcodesectornamemcappeepsfvbsegroupBSEListedNSEListedPE_conlatbvlatepsEV_EBIDTAEV_SalesDivYield
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 6
6 500410 ACC ACC ACC Ltd 00000011 Cement 45314.012 21.890 110.230 10.000 A Y Y 21.630 719.067 110.230 10.330 1.783 0.580
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 8
8 506947 NULL Advance Petroch. Advance Petrochemicals Ltd 00000014 Chemicals 15.390 58.560 2.920 10.000 X Y N 0.000 40.756 2.920 13.160 0.711 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 9
9 500003 AEGISLOG Aegis Logistics Aegis Logistics Ltd 00000064 Trading 27170.910 63.300 12.230 1.000 A Y Y 47.000 71.387 12.230 27.040 5.001 0.840
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 11
11 505216 ALFREDHERB Alfred Herbert Alfred Herbert (India) Ltd 00000026 Finance 159.780 25.640 80.940 10.000 X Y N 25.250 1419.018 80.940 160.990 73.175 0.190
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 14
14 500009 AMBASARABH Ambalal Sarabhai Ambalal Sarabhai Enterprises Ltd 00000046 Pharmaceuticals 278.030 21.860 1.660 10.000 X Y N 19.510 5.881 1.660 115.070 93.320 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 17
17 590006 AMRUTANJAN Amrutanjan Healt Amrutanjan Health Care Ltd 00000046 Pharmaceuticals 2026.780 41.090 17.060 1.000 B Y Y 0.000 103.003 17.060 25.840 4.187 0.660
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 19
19 532141 ACL Andhra Cements Andhra Cements Ltd 00000011 Cement 523.810 0.000 0.000 10.000 B Y Y 0.000 25.857 0.000 68.180 5.101 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 20
20 502330 ANDHRAPAP Andhra Paper Andhra Paper Ltd 00000044 Paper 1484.220 12.420 6.010 2.000 B Y Y 0.000 97.671 6.010 3.840 1.123 2.680
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 23
23 500877 APOLLOTYRE Apollo Tyres Apollo Tyres Ltd 00000065 Tyres 30364.180 40.450 11.820 1.000 A Y Y 22.500 163.675 11.820 10.370 1.868 1.250
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 24
24 500014 APPLEIND Utique Enterp. Utique Enterprises Ltd 00000064 Trading 26.170 18.800 0.250 10.000 X Y N 0.000 13.232 0.250 17.150 0.354 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 25
25 512344 ARAVALISEC Aravali Sec Aravali Securities & Finance Ltd 00000026 Finance 5.860 0.000 0.000 10.000 X Y N 0.000 -0.510 0.000 0.000 504.500 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 28
28 500016 ARUNASUGAR Aruna Hotels Aruna Hotels Ltd 00000031 Hotels & Restaurants 39.090 0.000 0.000 10.000 X Y N 0.000 -17.360 0.000 11.220 9.087 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 29
29 500101 ARVIND Arvind Ltd Arvind Ltd 00000062 Textiles 9435.920 40.090 8.990 10.000 A Y Y 31.310 130.197 8.990 10.480 1.176 1.320
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 31
31 500477 ASHOKLEY Ashok Leyland Ashok Leyland Ltd 00000005 Automobile 64721.059 22.150 9.950 1.000 A Y Y 23.220 34.360 9.950 10.320 1.257 2.250
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 33
33 500023 ASIANHOTNR Asian Hotels (N) Asian Hotels (North) Ltd 00000031 Hotels & Restaurants 649.930 0.000 0.000 10.000 T Y Y 0.000 -204.069 0.000 16.940 4.226 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 34
34 500820 ASIANPAINT Asian Paints Asian Paints Ltd 00000043 Paints/Varnish 231113.906 54.340 44.340 1.000 A Y Y 52.980 185.007 44.340 34.860 8.875 1.380
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 37
37 500472 SKFINDIA SKF India SKF India Ltd 00000066 Bearings 19393.279 36.060 108.790 10.000 A Y Y 36.060 463.918 108.790 23.870 4.238 3.310
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 38
38 502015 ASOCSTONE Asi Industries Asi Industries Ltd 00000038 Mining & Mineral products 313.100 10.800 3.220 1.000 X Y N 0.000 26.593 3.220 5.550 1.614 1.010
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 39
39 506820 ASTRAZEN Astrazeneca Phar Astrazeneca Pharma India Ltd 00000046 Pharmaceuticals 20924.631 124.830 67.050 2.000 A Y Y 0.000 271.740 67.050 54.310 9.880 0.290
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 42
42 505029 ATLASCYCLE Atlas Cycles Atlas Cycles (Haryana) Ltd 00000017 Consumer Durables 52.450 3.460 23.300 5.000 T Y Y 0.000 -36.127 23.300 0.000 0.000 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 43
43 500027 ATUL Atul Atul Ltd 00000014 Chemicals 20735.090 45.440 154.980 10.000 A Y Y 42.850 1881.033 154.980 24.270 3.877 0.350
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 44
44 505036 AUTOCORP Auto.Corp.of Goa Automobile Corporation Of Goa Ltd 00000004 Auto Ancillaries 895.850 22.020 66.810 10.000 T Y N 0.000 386.585 66.810 23.860 2.291 1.360
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 49
49 502125 NULL Bagalkot Udyog Bagalkot Udyog Ltd 00000026 Finance 20.320 0.000 0.000 1.000 NULL Y N 0.000 -0.871 0.000 0.000 0.000 0.000
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 50
50 500490 BAJAJHLDNG Bajaj Holdings Bajaj Holdings & Investment Ltd 00000026 Finance 133771.688 55.610 216.150 10.000 A Y Y 17.810 1839.405 216.150 30.210 29.057 1.090
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`co_code` = 51
51 500031 BAJAJELEC Bajaj Electrical Bajaj Electricals Ltd 00000017 Consumer Durables 6202.530 59.820 8.990 2.000 A Y Y 59.820 126.825 8.990 30.320 2.235 0.560
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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