• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 111 行, 查询花费 0.0025 秒。) [BILLSCOLL: 0.000... - 0.000...]
SELECT * FROM `HalfY_StandaloneBalanceSheet` ORDER BY `BILLSCOLL`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
|
行数：
过滤行:
按索引排序：
完整内容 CO_CODEYRCNOOFMONTHSbsecodensesymbolNOMSHARECAPEQSHWRNTEQWRAPMYRESTOTTOTLOANSLOANUSECLOANDEPOSITDTAXCLIABXOLIABLNFUNDSFIXASSETSINVESTADVANTOTCASSETINVTOTALSDBCASHOTHCASSETLOANSTOTCLIABNWCAPMEXPDTAXCASSETXASSETSESOPBORROWOTHLIBPRVCASHBKRBIBANKBALOTHASSTCONTLIABBILLSCOLL 递增 递减 1GOODWILLCURRLIABPROVPLACCTFCMTDALIABOTHERLIABFCMTDAASSTOTHERASSETFLAG
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 91836 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202503 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
91836 202503 2 544325 ITCHOTELS 6 208.120 0.000 0.000 10839.960 126.580 0.000 0.000 0.000 416.410 11637.430 0.000 5886.380 4615.560 0.000 1882.210 37.460 188.760 1500.340 155.440 0.210 884.740 997.470 0.000 0.000 11637.430 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 15.840 875.490 9.250 0.000 0.000 46.360 0.000 122.180 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201603 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
230 201603 2 500010 HDFC 6 315.970 51.100 0.000 33753.988 150794.938 0.000 0.000 0.000 902.210 189558.938 0.000 664.530 15345.430 0.000 36479.859 0.000 144.660 5320.670 2700.790 28313.740 99317.688 -62837.828 0.000 0.000 189558.938 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 96480.609 2837.080 0.000 0.000 3740.730 0.000 236386.797 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201609 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
230 201609 1 500010 HDFC 6 316.790 51.100 0.000 36676.852 177285.359 0.000 0.000 0.000 1505.750 220488.312 0.000 653.130 19990.939 0.000 39505.039 0.000 72.140 1447.010 1786.490 36199.398 89395.727 -49890.691 0.000 0.000 220488.312 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 89185.047 210.680 0.000 0.000 4652.460 0.000 249734.938 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201703 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
230 201703 2 500010 HDFC 6 317.730 51.100 0.000 39276.551 192192.562 0.000 0.000 0.000 2388.580 239691.797 0.000 638.210 20410.100 0.000 43429.148 0.000 109.480 6318.800 1187.140 35813.730 97614.250 -54185.102 0.000 0.000 239691.797 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 4.130 97437.883 176.370 0.000 0.000 5465.270 0.000 272824.438 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201709 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
230 201709 1 500010 HDFC 6 319.020 51.100 0.000 40395.648 208136.156 0.000 0.000 0.000 2531.580 255543.766 0.000 636.990 25105.359 0.000 34239.352 0.000 129.110 1161.920 1022.700 31925.619 102744.469 -68505.117 0.000 0.000 255543.766 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 4.750 102524.719 219.750 0.000 0.000 4110.270 0.000 298301.781 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201803 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
230 201803 2 500010 HDFC 6 335.180 0.000 0.000 64929.730 319715.688 0.000 0.000 0.000 0.000 385640.438 0.000 1034.840 30716.730 0.000 8375.800 0.000 103.450 1485.070 6787.280 0.000 13269.150 -4893.350 0.000 1279.500 385640.438 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 4.790 13086.610 182.540 0.000 0.000 659.840 0.000 357497.938 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201809 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
230 201809 1 500010 HDFC 6 339.320 0.000 0.000 70461.719 343172.375 0.000 0.000 0.000 0.000 414732.875 0.000 1036.470 38216.590 0.000 382758.594 0.000 145.350 322.850 8185.400 374105.000 12278.370 370480.219 0.000 988.260 414732.875 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 5.110 12278.370 0.000 0.000 0.000 759.440 0.000 4006.210 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201903 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
230 201903 2 500010 HDFC 6 344.290 0.000 0.000 77011.180 366214.375 0.000 0.000 0.000 0.000 444346.156 0.000 965.550 46240.352 0.000 9830.990 0.000 186.860 1596.260 8047.870 0.000 14431.390 -4600.400 0.000 830.910 444346.156 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 7.100 14221.840 209.550 0.000 0.000 776.300 0.000 400902.656 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201909 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
230 201909 1 500010 HDFC 6 345.340 0.000 0.000 81360.203 388976.000 0.000 0.000 0.000 0.000 471341.594 0.000 1244.060 58023.590 0.000 11064.550 0.000 138.520 1481.440 9444.590 419455.438 19489.789 -8425.240 0.000 857.190 471341.594 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 9.070 19261.039 228.750 0.000 0.000 660.050 0.000 177.480 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202003 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
230 202003 2 500010 HDFC 6 346.410 0.000 0.000 85811.648 419101.625 0.000 0.000 0.000 0.000 507226.156 0.000 1876.530 64944.371 0.000 15208.820 0.000 230.060 3425.690 11553.070 439943.281 16867.391 -1658.570 0.000 1567.940 507226.156 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 362.850 16606.850 260.540 0.000 0.000 1966.470 0.000 189.770 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202009 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
230 202009 1 500010 HDFC 6 359.160 0.000 0.000 99774.289 420899.062 0.000 0.000 0.000 0.000 522792.469 0.000 1927.480 61178.371 0.000 13072.090 0.000 149.070 383.300 12539.720 462845.000 18519.619 -5447.530 0.000 1749.430 522792.469 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 363.240 18279.539 240.080 0.000 0.000 1759.950 0.000 176.470 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 230 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202103 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
230 202103 2 500010 HDFC 6 360.790 0.000 0.000 108421.859 441365.031 0.000 0.000 0.000 0.000 551914.312 0.000 1826.990 68636.773 0.000 9484.160 0.000 155.380 1144.750 8184.030 485294.250 15684.290 -6200.130 0.000 1655.300 551914.312 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 369.460 15433.000 251.290 0.000 0.000 1766.600 0.000 331.640 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 119 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202503 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
119 202503 2 506390 HEUBACHIND 6 23.080 0.000 0.000 500.260 25.090 0.000 0.000 0.000 1.490 563.770 0.000 156.150 4.230 0.000 561.420 131.410 153.670 190.610 74.610 11.120 194.340 367.080 0.000 0.000 563.770 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8.940 184.750 9.590 0.000 0.000 13.850 0.000 27.370 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 119 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202403 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
119 202403 2 506390 HEUBACHIND 6 23.080 0.000 0.000 449.360 27.020 0.000 0.000 0.000 2.670 512.730 0.000 167.030 4.230 0.000 489.600 124.010 194.920 113.280 46.710 10.680 212.770 276.830 0.000 0.000 512.730 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8.940 202.020 10.750 0.000 0.000 10.600 0.000 55.700 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201612 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
6 201612 2 500410 ACC 6 187.990 0.000 0.000 8643.880 50.020 0.000 0.000 0.000 447.370 9470.620 0.000 7758.180 258.500 0.000 4071.350 1223.750 536.100 1945.070 337.550 28.880 3968.960 102.390 0.000 0.000 9470.620 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 27.590 3916.940 52.020 0.000 0.000 141.360 0.000 1323.960 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201706 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
6 201706 1 500410 ACC 6 187.990 0.000 0.000 9043.600 49.920 0.000 0.000 0.000 443.260 9870.820 0.000 7573.580 230.150 0.000 4790.370 1453.490 924.030 1754.680 591.900 66.270 4056.880 733.490 0.000 0.000 9870.820 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 27.660 4015.680 41.200 0.000 0.000 146.050 0.000 1305.940 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201712 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
6 201712 2 500410 ACC 6 187.990 0.000 0.000 9177.470 59.170 0.000 0.000 0.000 541.360 10108.020 0.000 7462.970 230.150 0.000 5604.730 1403.950 668.200 2695.400 796.220 40.960 4780.830 823.900 0.000 0.000 10108.020 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 39.770 4729.640 51.190 0.000 0.000 142.030 0.000 1551.230 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201806 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
6 201806 1 500410 ACC 6 187.990 0.000 0.000 9411.570 0.000 0.000 0.000 0.000 602.650 10320.240 0.000 7394.000 230.150 0.000 5678.490 1637.890 994.780 2077.960 922.180 45.680 4622.370 1056.120 0.000 0.000 10320.240 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 39.890 4599.030 23.340 0.000 0.000 118.030 0.000 1600.080 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201812 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
6 201812 2 500410 ACC 6 187.990 0.000 0.000 10339.670 0.000 0.000 0.000 0.000 663.090 11330.270 0.000 7404.370 230.150 0.000 6570.420 1678.560 868.260 3000.330 944.400 78.870 4694.780 1875.640 0.000 0.000 11330.270 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 37.220 4667.480 27.300 0.000 0.000 139.520 0.000 1782.890 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201906 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
6 201906 1 500410 ACC 6 187.990 0.000 0.000 10787.550 0.000 0.000 0.000 0.000 638.800 11796.450 0.000 7362.160 230.150 0.000 7037.810 1611.520 1205.760 2949.440 1234.300 36.790 4662.380 2375.430 0.000 0.000 11796.450 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 35.760 4635.630 26.750 0.000 0.000 182.110 0.000 1792.950 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 201912 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
6 201912 2 500410 ACC 6 187.990 0.000 0.000 11333.290 0.000 0.000 0.000 0.000 642.210 12397.620 0.000 7392.620 230.150 0.000 7412.830 1140.950 628.430 4538.100 1073.920 31.430 4684.480 2728.350 0.000 0.000 12397.620 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 34.090 4661.090 23.390 0.000 0.000 234.130 0.000 2012.410 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202006 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
6 202006 1 500410 ACC 6 187.990 0.000 0.000 11656.020 96.640 0.000 0.000 0.000 634.770 12802.630 0.000 7352.190 230.150 0.000 7708.890 1248.360 694.000 4722.160 998.910 45.460 4562.520 3146.370 0.000 0.000 12802.630 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 39.990 4528.480 34.040 0.000 0.000 227.210 0.000 2033.930 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202012 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
6 202012 2 500410 ACC 6 187.990 0.000 0.000 12473.450 83.980 0.000 0.000 0.000 376.200 13335.190 0.000 7158.100 220.630 0.000 8327.590 900.470 451.530 5891.090 1024.700 59.800 4790.740 3536.850 0.000 0.000 13335.190 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 45.800 4774.870 15.870 0.000 0.000 213.570 0.000 2373.810 O
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 6 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202106 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 1
6 202106 1 500410 ACC 6 187.990 0.000 0.000 13315.380 99.070 0.000 0.000 0.000 385.740 14190.260 0.000 7223.000 192.730 0.000 9045.990 1316.900 829.020 5728.960 1110.080 61.030 4814.110 4231.880 0.000 0.000 14190.260 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 44.360 4795.210 18.900 0.000 0.000 202.080 0.000 2498.290 A
编辑 编辑复制 复制删除 删除
DELETE FROM `HalfY_StandaloneBalanceSheet` WHERE `HalfY_StandaloneBalanceSheet`.`CO_CODE` = 119 AND `HalfY_StandaloneBalanceSheet`.`YRC` = 202303 AND `HalfY_StandaloneBalanceSheet`.`NOOFMONTHS` = 2
119 202303 2 506390 HEUBACHIND 6 23.080 0.000 0.000 409.340 0.000 0.000 0.000 0.000 5.710 445.440 0.000 144.820 3.000 0.000 456.930 129.300 217.730 38.820 60.980 10.100 216.290 240.640 0.000 0.000 445.440 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8.940 205.620 10.670 0.000 0.000 7.310 0.000 48.040 O
选中项： 选中项：
|
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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