将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 149 行, 查询花费 0.0022 秒。)
SELECT * FROM `AnnualKeyFinanceRatios`
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
|
行数：
过滤行:
按索引排序：
完整内容 CO_CODEYRCbsecodensesymbolDTELTDTECRFATOINVTODRSTOINTCOVERPBIDTMPBITMPBDTMCPMAPATMROCERONWCREDDEPTINVTDEPTCASHDEPTIETOIEOITOTIOETOTIIITOTFIETOTFNETITOTFNONIITOTFOETOTFPBPTOTFNPTOTFLOANTOADVTOLFTITOCEIETOCETATOFLAG
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 6 AND `AnnualKeyFinanceRatios`.`YRC` = 201612
6 201612 500410 ACC 0.000 0.000 0.730 1.290 10.380 24.540 11.550 12.450 7.620 11.790 10.000 5.170 10.830 7.490 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.420 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 6 AND `AnnualKeyFinanceRatios`.`YRC` = 201712
6 201712 500410 ACC 0.010 0.000 0.980 1.710 10.810 23.580 13.690 14.370 9.860 13.650 10.950 6.450 15.070 10.060 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.530 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 6 AND `AnnualKeyFinanceRatios`.`YRC` = 201812
6 201812 500410 ACC 0.000 0.000 1.130 1.710 9.600 19.270 17.750 14.750 10.700 14.150 14.230 10.180 15.650 15.150 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.460 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 6 AND `AnnualKeyFinanceRatios`.`YRC` = 201912
6 201912 500410 ACC 0.000 0.000 1.300 1.710 11.110 20.920 24.560 17.380 13.530 16.830 12.530 8.680 18.890 12.330 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.400 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 6 AND `AnnualKeyFinanceRatios`.`YRC` = 202012
6 202012 500410 ACC 0.000 0.000 1.480 1.440 13.500 25.530 33.680 18.540 13.930 18.130 15.740 11.130 15.540 12.690 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.120 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 20 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
20 202403 502330 ANDHRAPAP 0.050 0.000 0.940 1.540 8.770 17.280 104.320 29.210 25.550 28.960 22.530 18.870 25.220 19.550 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.990 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 20 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
20 202503 502330 ANDHRAPAP 0.100 0.000 0.960 1.050 5.510 18.180 5.330 11.920 6.190 10.750 9.550 3.820 4.500 3.070 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.730 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 42 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
42 202403 505029 ATLASCYCLE 0.000 0.000 0.590 0.060 0.840 0.600 -1213.250 -729.090 -763.050 -729.720 -729.720 -763.680 -76.220 -105.020 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.030 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 42 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
42 202503 505029 ATLASCYCLE 0.000 0.000 0.680 0.210 5.870 5.860 80.250 66.450 56.180 65.750 65.750 55.480 6.550 7.620 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.040 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 69 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
69 202403 500493 BHARATFORG 0.590 0.000 1.240 1.520 6.920 2.610 7.590 29.270 24.340 26.060 20.820 15.890 16.820 17.520 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.690 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 69 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
69 202503 500493 BHARATFORG 0.460 0.000 1.310 1.410 6.160 2.380 8.280 28.370 23.390 25.540 19.930 14.950 14.390 13.540 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.620 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 103 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
103 202403 513375 CARBORUNIV 0.020 0.000 2.520 2.520 7.110 6.850 112.590 20.500 17.740 20.350 16.060 13.310 21.070 16.300 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.190 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 103 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
103 202503 513375 CARBORUNIV 0.000 0.000 3.430 2.430 7.040 6.810 2502.760 17.900 15.050 17.890 14.230 11.370 17.400 13.260 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.160 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 105 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
105 202403 509496 ITDCEM 0.610 0.000 1.040 5.110 12.060 6.800 2.750 10.550 7.850 7.700 6.330 3.630 26.410 20.040 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 3.360 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 105 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
105 202503 509496 ITDCEM 0.560 0.000 1.100 5.240 13.560 6.530 3.170 10.180 8.070 7.630 6.260 4.150 27.400 22.410 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 3.390 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 112 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
112 202403 501833 CHOWGULSTM 0.000 0.000 1.210 0.320 0.000 9.510 7.540 110.510 99.510 97.310 96.090 85.090 3.610 3.250 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.090 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 112 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
112 202503 501833 CHOWGULSTM 0.000 0.000 1.650 0.280 0.000 9.700 5.590 72.680 63.400 61.340 42.530 33.250 2.230 1.200 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.080 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 197 AND `AnnualKeyFinanceRatios`.`YRC` = 202203
197 202203 505744 FMGOETZE 0.010 0.000 1.780 0.890 7.630 5.120 15.540 11.870 5.740 11.500 10.120 3.990 8.920 6.730 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.550 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 197 AND `AnnualKeyFinanceRatios`.`YRC` = 202303
197 202303 505744 FMGOETZE 0.010 0.000 1.790 1.050 9.020 6.130 27.980 13.120 8.310 12.820 10.850 6.040 14.850 11.290 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.790 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 197 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
197 202403 505744 FMGOETZE 0.010 0.000 2.020 1.060 9.140 6.160 31.360 15.040 10.390 14.710 12.140 7.490 17.210 12.820 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.660 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 230 AND `AnnualKeyFinanceRatios`.`YRC` = 201603
230 201603 500010 HDFC 6.860 0.000 1.910 0.000 0.000 0.000 0.000 95.410 95.240 32.830 23.090 22.910 11.360 21.790 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.130 108.960 11.930 7.460 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 230 AND `AnnualKeyFinanceRatios`.`YRC` = 201703
230 201703 500010 HDFC 7.020 0.000 2.030 0.000 0.000 0.000 0.000 95.530 95.370 32.520 22.610 22.440 10.530 20.180 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.120 107.270 11.040 6.960 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 230 AND `AnnualKeyFinanceRatios`.`YRC` = 201803
230 201803 500010 HDFC 5.710 0.000 3.380 0.000 0.000 0.000 0.000 90.250 90.120 32.520 27.040 26.920 10.330 20.890 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.120 109.070 11.460 6.610 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 230 AND `AnnualKeyFinanceRatios`.`YRC` = 201903
230 201903 500010 HDFC 4.810 0.000 7.130 0.000 0.000 0.000 0.000 94.570 94.420 30.400 22.360 22.210 9.880 13.510 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.110 110.520 10.460 6.710 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 230 AND `AnnualKeyFinanceRatios`.`YRC` = 202003
230 202003 500010 HDFC 4.800 0.000 8.570 0.000 0.000 0.000 0.000 87.640 87.390 34.880 30.490 30.240 10.820 21.730 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.140 107.040 12.390 6.530 0.000 O
选中项： 选中项：
|
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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