将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 149 行, 查询花费 0.0021 秒。) [nsesymbol: AARVI... - CYIENT...]
SELECT * FROM `AnnualKeyFinanceRatios` ORDER BY `nsesymbol`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
|
行数：
过滤行:
按索引排序：
完整内容 CO_CODEYRCbsecodensesymbol 递增 递减 1DTELTDTECRFATOINVTODRSTOINTCOVERPBIDTMPBITMPBDTMCPMAPATMROCERONWCREDDEPTINVTDEPTCASHDEPTIETOIEOITOTIOETOTIIITOTFIETOTFNETITOTFNONIITOTFOETOTFPBPTOTFNPTOTFLOANTOADVTOLFTITOCEIETOCETATOFLAG
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 44508 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
44508 202403 535014 AARVI 0.070 0.000 2.130 21.310 0.000 5.020 6.900 3.750 3.420 3.250 3.070 2.740 12.280 10.610 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.590 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 44508 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
44508 202503 535014 AARVI 0.180 0.000 1.940 20.580 0.000 5.520 3.200 3.040 2.700 2.190 2.000 1.670 10.000 7.420 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.710 A
编辑 编辑复制 复制删除 删除
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` = 24853 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
24853 202503 532633 ALLDIGI 0.110 0.000 1.860 3.210 0.000 6.760 22.850 31.240 22.770 30.240 25.250 16.780 32.880 27.710 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.440 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 24853 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
24853 202403 532633 ALLDIGI 0.160 0.000 2.080 3.350 0.000 7.140 23.550 35.260 27.520 34.090 28.860 21.130 38.450 35.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.400 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` = 27798 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
27798 202503 532888 ASIANTILES 0.080 0.000 2.100 3.580 10.620 3.210 3.430 4.100 2.600 3.340 3.620 2.120 2.340 2.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 0.900 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 27798 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
27798 202403 532888 ASIANTILES 0.060 0.000 2.390 3.690 9.150 3.370 4.780 5.460 3.920 4.640 3.800 2.260 3.870 2.370 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` = 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` = 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` = 77460 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
77460 202403 543896 AVALON 0.120 0.000 3.420 7.010 2.420 2.880 17.700 11.560 10.380 10.970 8.530 7.360 6.090 4.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.000 0.000 0.000 0.000 0.590 O
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 3116 AND `AnnualKeyFinanceRatios`.`YRC` = 202503
3116 202503 532230 BENGALTEA 0.040 0.000 0.320 0.820 11.860 122.110 22.050 19.040 15.190 18.350 158.910 155.050 5.200 55.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 0.340 A
编辑 编辑复制 复制删除 删除
DELETE FROM `AnnualKeyFinanceRatios` WHERE `AnnualKeyFinanceRatios`.`CO_CODE` = 3116 AND `AnnualKeyFinanceRatios`.`YRC` = 202403
3116 202403 532230 BENGALTEA 0.060 0.000 0.610 0.920 4.310 96.760 6.320 7.610 4.170 6.950 -0.780 -4.220 1.970 -2.130 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.470 O
编辑 编辑复制 复制删除 删除
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` = 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` = 13660 AND `AnnualKeyFinanceRatios`.`YRC` = 201703
13660 201703 532175 CYIENT 0.000 0.000 5.260 4.900 0.000 4.490 479.330 26.440 22.260 26.390 22.520 18.340 15.630 13.310 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.700 O
选中项： 选中项：
|
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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