• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 46467 行, 查询花费 0.1095 秒。) [SDB: -21.820... - -0.010...]
SELECT * FROM `HalfY_StandaloneBalanceSheet` ORDER BY `SDB`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 CO_CODEYRCNOOFMONTHSbsecodensesymbolNOMSHARECAPEQSHWRNTEQWRAPMYRESTOTTOTLOANSLOANUSECLOANDEPOSITDTAXCLIABXOLIABLNFUNDSFIXASSETSINVESTADVANTOTCASSETINVTOTALSDB 递增 递减 1CASHOTHCASSETLOANSTOTCLIABNWCAPMEXPDTAXCASSETXASSETSESOPBORROWOTHLIBPRVCASHBKRBIBANKBALOTHASSTCONTLIABBILLSCOLLGOODWILLCURRLIABPROVPLACCTFCMTDALIABOTHERLIABFCMTDAASSTOTHERASSETFLAG
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6864 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202409 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
6864 202409 1 509024 NULL 6 14.870 0.000 0.000 -0.270 6.660 0.000 0.000 0.000 0.000 22.390 0.000 2.410 0.000 0.000 15.290 0.000 -21.820 23.790 0.000 13.320 5.050 10.240 0.000 0.250 22.390 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 9.630 5.040 0.010 0.000 0.000 1.130 0.000 -0.140 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 43829 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202409 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
43829 202409 1 536737 NULL 6 9.780 0.000 0.000 73.050 37.880 0.000 0.000 0.000 0.170 121.540 0.000 4.190 0.070 0.000 70.390 59.230 -11.550 6.490 0.930 59.020 -3.170 73.560 0.000 0.000 121.540 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 -3.550 0.380 0.000 0.000 0.660 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 75626 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202309 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
75626 202309 1 543522 NULL 6 4.670 0.000 0.000 17.000 0.000 0.000 0.000 0.000 0.000 21.670 0.000 0.250 0.000 0.000 26.280 16.560 -4.880 8.520 0.120 5.950 4.860 21.410 0.000 0.000 21.670 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 4.800 0.060 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 43829 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202403 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
43829 202403 2 536737 NULL 6 9.780 0.000 0.000 72.930 26.870 0.000 0.000 0.000 0.170 111.320 0.000 4.230 0.070 0.000 107.240 54.420 -3.440 7.290 1.030 47.940 0.210 107.030 0.000 0.000 111.320 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 -0.130 0.340 0.000 0.000 1.580 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 12667 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202409 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
12667 202409 1 531262 NULL 6 12.330 0.000 0.000 -1.500 0.000 0.000 0.000 0.000 0.000 10.830 0.000 0.000 0.050 0.000 19.440 3.360 -2.590 0.090 0.450 18.140 8.670 10.770 0.000 0.000 10.830 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8.560 0.110 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 5398 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202009 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
5398 202009 1 531043 NULL 6 4.150 0.000 0.000 4.940 0.100 0.000 0.000 0.000 0.000 10.250 0.000 10.190 0.000 0.000 1.120 0.100 -0.850 0.840 1.040 0.000 2.080 -0.960 0.000 0.140 10.250 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 2.080 0.000 0.000 0.000 1.050 0.000 0.890 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 34869 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202409 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
34869 202409 1 535105 SUPREMEENG 6 25.000 0.000 0.000 -104.400 102.480 0.000 0.000 0.000 0.000 23.080 0.000 17.560 0.000 0.000 16.060 10.130 -0.600 2.420 4.110 0.000 13.260 2.800 0.000 2.460 23.080 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 13.020 0.240 0.000 0.000 0.000 0.000 0.260 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 12667 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202203 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
12667 202203 2 531262 NULL 6 12.330 0.000 0.000 -1.490 0.000 0.000 0.000 0.000 0.000 20.800 0.000 0.000 0.050 0.000 20.750 0.070 -0.550 0.050 0.090 21.080 0.000 20.750 0.000 0.000 20.800 0.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 9.960 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 3276 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202009 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
3276 202009 1 511391 NULL 6 6.820 0.000 0.000 84.380 3.040 0.000 0.000 0.000 0.000 94.240 0.000 0.550 0.300 0.000 21.110 16.220 -0.540 1.140 4.290 0.000 10.490 10.630 0.000 0.000 94.240 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.430 9.060 0.000 0.000 0.000 0.000 82.770 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 1668 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202009 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
1668 202009 1 501421 NULL 6 6.280 0.000 0.000 8.750 0.000 0.000 0.000 0.000 0.000 15.020 0.000 1.220 9.530 0.000 5.480 0.000 -0.440 2.000 0.000 3.920 1.310 4.180 0.000 0.100 15.020 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.900 0.410 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 64981 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202209 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
64981 202209 1 538834 NULL 6 12.400 0.000 0.000 -0.270 0.000 0.000 0.000 0.000 0.000 12.130 0.000 0.030 0.000 0.000 1.910 1.800 -0.350 0.460 0.000 10.940 1.040 0.870 0.000 0.000 12.130 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.960 0.070 0.000 0.000 0.000 0.000 0.290 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 12667 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202303 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
12667 202303 2 531262 NULL 6 12.330 0.000 0.000 -1.470 0.380 0.000 0.000 0.000 0.000 11.240 0.000 0.000 0.050 0.000 0.050 0.070 -0.300 0.050 0.240 0.000 7.290 -7.240 0.000 0.000 11.240 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 7.030 0.260 0.000 0.000 0.000 0.000 18.430 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 12667 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202109 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
12667 202109 1 531262 NULL 6 12.330 0.000 0.000 -1.580 0.000 0.000 0.000 0.000 0.000 11.080 0.000 0.000 0.050 0.000 16.510 0.100 -0.250 0.040 0.040 16.570 5.480 11.030 0.000 0.000 11.080 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 5.480 0.000 0.000 0.000 0.340 0.000 0.000 A
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 7734 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202209 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
7734 202209 1 540696 NULL 6 1.000 0.000 0.000 2.730 0.000 0.000 0.000 0.000 0.000 3.730 0.000 0.010 0.000 0.000 6.250 0.790 -0.210 0.030 5.640 0.000 2.540 3.720 0.000 0.000 3.730 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 2.430 0.110 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 3489 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202009 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
3489 202009 1 526373 NULL 6 3.560 0.000 0.000 4.400 1.220 0.000 0.000 0.000 0.030 9.830 0.000 8.160 0.300 0.000 1.550 0.680 -0.140 0.020 0.050 0.940 0.180 1.370 0.000 0.000 9.830 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.180 0.010 0.000 0.000 0.610 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 12483 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202309 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
12483 202309 1 531191 NULL 6 2.620 0.000 0.000 -6.180 3.010 0.000 0.000 0.000 0.000 -0.550 0.000 0.960 0.000 0.000 0.160 0.220 -0.130 0.000 0.050 0.010 1.670 -1.510 0.000 0.000 -0.550 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.670 0.000 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 5018 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202303 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
5018 202303 2 530795 NULL 6 4.950 0.000 0.000 -4.990 4.750 0.000 0.000 0.000 0.000 4.710 0.000 2.990 0.030 0.000 1.920 1.770 -0.100 0.220 0.040 0.000 0.670 1.250 0.000 0.200 4.710 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.640 0.030 0.000 0.000 0.000 0.000 0.230 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 34869 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202403 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
34869 202403 2 535105 SUPREMEENG 6 25.000 0.000 0.000 -102.070 88.450 0.000 0.000 0.000 0.000 11.390 0.000 15.590 0.010 0.000 14.760 9.610 -0.090 2.170 3.070 0.000 21.810 -7.050 0.000 2.370 11.390 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 21.630 0.180 0.000 0.000 0.010 0.000 0.470 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 4681 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202203 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
4681 202203 2 519612 NULL 6 3.500 0.000 0.000 14.740 0.000 0.000 0.000 0.000 0.020 18.260 0.000 0.200 6.560 0.000 11.670 0.000 -0.060 10.770 0.100 0.870 0.170 11.500 0.000 0.000 18.260 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.050 0.120 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 4681 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202209 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
4681 202209 1 519612 NULL 6 3.500 0.000 0.000 15.010 0.000 0.000 0.000 0.000 0.020 18.530 0.000 0.170 0.000 0.000 18.550 0.000 -0.060 17.610 0.110 0.900 0.200 18.350 0.000 0.000 18.530 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.050 0.150 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 26837 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202209 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
26837 202209 1 532692 RMCL 6 6.850 0.000 0.000 -14.380 0.000 0.000 0.000 0.000 0.000 0.390 0.000 25.540 0.000 0.000 11.490 0.100 -0.060 5.790 5.660 0.000 37.120 -25.630 0.000 0.000 0.390 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.030 37.120 0.000 0.000 0.000 7.920 0.000 0.450 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 45950 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202303 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
45950 202303 2 538731 NULL 6 10.500 0.000 0.000 -8.670 1.000 0.000 0.000 0.000 0.000 2.830 0.000 1.400 0.210 0.000 1.620 0.140 -0.040 0.000 0.000 1.530 1.220 0.410 0.000 0.000 2.830 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.810 0.740 0.470 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 45950 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202309 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
45950 202309 1 538731 NULL 6 10.500 0.000 0.000 -8.670 1.000 0.000 0.000 0.000 0.000 2.830 0.000 1.400 0.210 0.000 1.620 0.140 -0.040 0.000 0.000 1.530 1.220 0.410 0.000 0.000 2.830 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.810 0.740 0.470 0.000 0.000 0.000 0.000 0.000 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 24399 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202109 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
24399 202109 1 538952 NULL 6 5.000 0.000 0.000 0.710 1.740 0.000 0.000 0.000 0.000 7.450 0.000 0.020 0.650 0.000 6.490 6.180 -0.020 0.080 0.250 0.000 0.300 6.180 0.000 0.020 7.450 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.250 0.060 0.000 0.000 0.000 0.000 0.570 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 3230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202309 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
3230 202309 1 522150 NULL 6 4.310 0.000 0.000 -16.970 8.030 0.000 0.000 0.000 0.000 -1.440 0.000 1.800 0.160 0.000 3.980 2.680 -0.010 0.170 0.470 0.670 8.780 -4.800 0.000 0.140 -1.440 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8.540 0.240 0.000 0.000 3.190 0.000 1.260 O
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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