• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 21129 行, 查询花费 0.0413 秒。) [MEXP: 0.000... - 0.000...]
SELECT * FROM `HalfY_ConsolidatedBalanceSheet` ORDER BY `MEXP`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 CO_CODEYRCNOOFMONTHSbsecodensesymbolNOMSHARECAPEQSHWRNTEQWRAPMYRESTOTTOTLOANSLOANUSECLOANDEPOSITDTAXCLIABXOLIABLNFUNDSFIXASSETSINVESTADVANTOTCASSETINVTOTALSDBCASHOTHCASSETLOANSTOTCLIABNWCAPMEXP 递增 递减 1DTAXCASSETXASSETSESOPBORROWOTHLIBPRVCASHBKRBIBANKBALOTHASSTCONTLIABBILLSCOLLGOODWILLCURRLIABPROVPLACCTMININTLPOLICYLIABFCMTDALIABOTHERLIABFCMTDAASSTOTHERASSETFLAG
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 94008 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202409 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
94008 202409 1 544289 NTPCGREEN 6 7500.000 0.000 0.000 689.180 18044.471 0.000 0.000 0.000 1301.030 29569.061 0.000 28106.641 16.670 0.000 2054.560 28.370 461.070 1455.440 109.680 0.000 2839.240 -784.680 0.000 0.000 29569.061 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 2839.160 0.080 0.000 91.820 0.000 0.000 1942.570 0.000 2230.430 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202309 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 202309 1 500410 ACC 6 187.990 0.000 0.000 14631.040 406.820 0.000 0.000 0.000 473.510 15882.680 0.000 9780.930 164.540 0.000 9349.490 1751.520 1481.600 1005.960 5105.640 4.770 6254.720 3094.770 0.000 0.000 15882.680 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 156.120 6244.620 10.100 0.000 3.550 0.000 0.000 179.770 0.000 2686.320 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202403 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 202403 2 500410 ACC 6 187.990 0.000 0.000 16140.230 354.850 0.000 0.000 0.000 563.610 17401.990 0.000 10266.260 810.550 0.000 8967.420 1868.550 827.500 1862.870 4404.900 3.600 5965.750 3001.670 0.000 0.000 17401.990 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 726.920 5953.620 12.130 0.000 3.640 0.000 0.000 151.670 0.000 2596.590 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202409 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 202409 1 500410 ACC 6 187.990 0.000 0.000 16532.811 457.410 0.000 0.000 0.000 548.060 17919.461 0.000 11444.900 821.460 0.000 8456.270 1868.430 1156.720 1183.320 4242.000 5.800 5799.340 2656.930 0.000 0.000 17919.461 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 394.630 5787.830 11.510 0.000 3.720 0.000 0.000 189.470 0.000 2601.540 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202003 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
9 202003 2 500003 AEGISLOG 6 33.970 0.000 0.000 1620.640 215.550 0.000 0.000 0.000 30.900 2323.350 0.000 1917.560 7.310 0.000 844.320 42.110 454.030 263.440 84.740 0.000 597.350 246.970 0.000 47.320 2323.350 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.250 593.330 4.020 0.000 90.600 0.000 0.000 331.690 0.000 102.940 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202009 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
9 202009 1 500003 AEGISLOG 6 34.540 0.000 0.000 1721.820 228.470 0.000 0.000 0.000 35.020 2462.600 0.000 2004.050 0.010 0.000 804.320 26.530 221.120 366.840 189.830 0.000 441.180 363.140 0.000 39.580 2462.600 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.250 437.160 4.020 0.000 104.850 0.000 0.000 337.900 0.000 54.570 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202103 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
9 202103 2 500003 AEGISLOG 6 35.100 0.000 0.000 1901.370 734.200 0.000 0.000 0.000 80.910 2909.830 0.000 2197.050 0.010 0.000 601.750 52.390 94.150 335.630 119.580 0.000 172.320 429.430 0.000 40.190 2909.830 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.250 169.160 3.160 0.000 109.020 0.000 0.000 49.230 0.000 241.900 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202109 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
9 202109 1 500003 AEGISLOG 6 35.100 0.000 0.000 2088.220 654.070 0.000 0.000 0.000 80.630 3060.570 0.000 2287.110 0.010 0.000 680.790 62.910 101.980 354.480 161.420 0.000 182.270 498.520 0.000 42.880 3060.570 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.720 179.110 3.160 0.000 148.690 0.000 0.000 53.860 0.000 230.330 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202203 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
9 202203 2 500003 AEGISLOG 6 35.100 0.000 0.000 2144.700 835.310 0.000 0.000 0.000 73.020 3225.500 0.000 2627.080 0.010 0.000 1183.390 90.640 738.340 150.180 204.230 0.000 808.640 374.750 0.000 75.500 3225.500 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.250 803.600 5.040 0.000 82.590 0.000 0.000 54.780 0.000 146.910 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202209 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
9 202209 1 500003 AEGISLOG 6 35.100 0.000 0.000 3297.430 1536.640 0.000 0.000 0.000 85.600 5515.010 0.000 3881.550 111.520 0.000 2076.490 205.680 397.950 1197.650 275.210 0.000 885.880 1190.610 0.000 171.100 5515.010 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8.640 879.490 6.390 0.000 499.050 0.000 0.000 61.190 0.000 151.590 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202303 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
9 202303 2 500003 AEGISLOG 6 35.100 0.000 0.000 3497.240 1923.900 0.000 0.000 0.000 93.360 6121.600 0.000 4057.990 204.340 0.000 2554.460 147.470 838.590 1265.110 303.290 0.000 1041.090 1513.370 0.000 174.260 6121.600 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 14.830 1030.790 10.300 0.000 514.480 0.000 0.000 57.520 0.000 156.810 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 9 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202309 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
9 202309 1 500003 AEGISLOG 6 35.100 0.000 0.000 3610.390 2358.980 0.000 0.000 0.000 88.820 6690.840 0.000 4316.460 0.010 0.000 2544.690 123.280 399.320 1744.030 278.060 0.000 503.280 2041.410 0.000 177.410 6690.840 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 16.090 492.930 10.350 0.000 532.960 0.000 0.000 64.590 0.000 139.460 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202212 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 202212 2 500410 ACC 6 187.990 0.000 0.000 13698.050 131.810 0.000 0.000 0.000 441.350 14660.230 0.000 8974.480 161.230 0.000 8093.880 1751.980 771.100 2993.110 2571.570 6.120 5429.630 2664.250 0.000 0.000 14660.230 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 62.190 5417.940 11.690 0.000 3.460 0.000 0.000 197.570 0.000 2798.080 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202206 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 202206 1 500410 ACC 6 187.990 0.000 0.000 13672.580 122.170 0.000 0.000 0.000 432.710 14607.650 0.000 8837.360 157.460 0.000 9132.590 2034.120 1088.000 4682.040 1322.650 5.780 5968.300 3164.290 0.000 0.000 14607.650 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 3.770 5956.610 11.690 0.000 3.400 0.000 0.000 188.800 0.000 2444.770 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 201612 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 201612 2 500410 ACC 6 187.990 0.000 0.000 8453.530 0.000 0.000 0.000 0.000 559.350 9335.350 0.000 7751.080 1687.000 0.000 2470.770 1224.630 466.350 278.400 60.960 440.430 4051.180 -1580.410 0.000 0.000 9335.350 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 9.690 3444.140 607.040 0.000 2.780 0.000 0.000 131.700 0.000 1467.990 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 201706 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 201706 1 500410 ACC 6 187.990 0.000 0.000 9029.260 0.000 0.000 0.000 0.000 452.300 9818.430 0.000 7604.970 89.920 0.000 4827.530 1454.380 920.330 1788.080 597.680 67.060 4065.660 761.870 0.000 0.000 9818.430 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 44.230 4024.460 41.200 0.000 2.830 0.000 0.000 146.050 0.000 1317.440 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 201712 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 201712 2 500410 ACC 6 187.990 0.000 0.000 9167.860 0.000 0.000 0.000 0.000 551.560 10053.080 0.000 7493.710 94.860 0.000 5641.840 1404.780 665.970 2728.550 801.140 41.400 4792.660 849.180 0.000 0.000 10053.080 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 55.600 4741.470 51.190 0.000 2.880 0.000 0.000 142.790 0.000 1559.730 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 201806 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 201806 1 500410 ACC 6 187.990 0.000 0.000 9410.430 0.000 0.000 0.000 0.000 612.590 10332.760 0.000 7423.050 99.300 0.000 5780.290 1638.730 992.650 2177.020 926.550 45.340 4635.390 1144.900 0.000 0.000 10332.760 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 56.530 4612.040 23.350 0.000 2.960 0.000 0.000 118.790 0.000 1608.980 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 201812 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 201812 2 500410 ACC 6 187.990 0.000 0.000 10343.910 0.000 0.000 0.000 0.000 674.570 11349.790 0.000 7432.960 104.100 0.000 6672.890 1679.390 867.370 3096.980 951.850 77.300 4706.160 1966.730 0.000 0.000 11349.790 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 52.990 4678.860 27.300 0.000 3.030 0.000 0.000 140.290 0.000 1793.010 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 201906 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 201906 1 500410 ACC 6 187.990 0.000 0.000 10803.690 0.000 0.000 0.000 0.000 650.160 11827.850 0.000 7385.780 110.180 0.000 7147.900 1612.480 1204.760 3056.370 1239.520 34.770 4671.250 2476.650 0.000 0.000 11827.850 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 51.510 4644.490 26.760 0.000 3.100 0.000 0.000 182.910 0.000 1803.730 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 201912 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 201912 2 500410 ACC 6 187.990 0.000 0.000 11355.780 0.000 0.000 0.000 0.000 655.720 12437.750 0.000 7422.560 116.180 0.000 7524.100 1141.930 626.650 4647.730 1078.770 29.020 4698.230 2825.870 0.000 0.000 12437.750 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 49.840 4674.840 23.390 0.000 3.160 0.000 0.000 235.100 0.000 2023.300 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202006 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 202006 1 500410 ACC 6 187.990 0.000 0.000 11684.430 96.640 0.000 0.000 0.000 648.210 12848.680 0.000 7381.810 120.540 0.000 7820.910 1249.660 695.360 4830.880 1002.090 42.920 4574.540 3246.370 0.000 0.000 12848.680 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 55.740 4540.500 34.040 0.000 3.210 0.000 0.000 228.200 0.000 2044.220 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202012 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 202012 2 500410 ACC 6 187.990 0.000 0.000 12511.140 83.980 0.000 0.000 0.000 394.790 13395.970 0.000 7232.360 129.270 0.000 8445.720 901.270 451.410 6005.700 1028.350 58.990 4804.260 3641.460 0.000 0.000 13395.970 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 10.190 4788.390 15.870 0.000 3.240 0.000 0.000 214.830 0.000 2382.690 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202106 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 1
6 202106 1 500410 ACC 6 187.990 0.000 0.000 13393.830 99.070 0.000 0.000 0.000 404.260 14291.800 0.000 7295.100 147.190 0.000 9167.050 1317.670 828.400 5847.200 1113.570 60.210 4828.220 4338.830 0.000 0.000 14291.800 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 3.770 4809.320 18.900 0.000 3.290 0.000 0.000 203.360 0.000 2506.910 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_ConsolidatedBalanceSheet` WHERE `HalfY_ConsolidatedBalanceSheet`.`CO_CODE` = 6 AND `HalfY_ConsolidatedBalanceSheet`.`YRC` = 202112 AND `HalfY_ConsolidatedBalanceSheet`.`NOOFMONTHS` = 2
6 202112 2 500410 ACC 6 187.990 0.000 0.000 14120.840 125.580 0.000 0.000 0.000 403.700 15057.010 0.000 7991.020 149.550 0.000 10367.050 1273.910 457.220 7523.710 1105.610 6.600 5981.830 4385.220 0.000 0.000 15057.010 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 3.770 5966.130 15.700 0.000 3.350 0.000 0.000 215.550 0.000 2527.450 O
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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