将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 18014 行, 查询花费 0.0704 秒。) [Cash_Earnings_Retention: -9490.09... - -187.26...]
SELECT * FROM `FinanceRatios` ORDER BY `Cash_Earnings_Retention` ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 fin_codeYear_endTypeReported_EPSAdjusted_EPSCEPSDPSBook_NAV_ShareTax_RateCore_EBITDA_MarginEBIT_MarginPre_Tax_MarginPAT_MarginCash_Profit_MarginROAROEROCEAsset_TurnoverSales_Fixed_AssetWorking_Capital_SalesFixed_Capital_SalesReceivable_daysInventory_DaysPayable_daysPERPCEPrice_BookYieldEV_Net_SalesEV_Core_EBITDAEV_EBITEV_CEMCap_SalesNet_Sales_GrowthPBIDT_Excl_OI_GrowthCore_EBITDA_GrowthEBIT_GrowthPAT_GrowthAdj_PAT_GrowthAdj_EPS_GrowthReported_EPS_GrowthTotal_Debt_EquityCurrent_RatioQuick_RatioInterest_CoverTotal_Debt_McapYield_AdvYield_InvCost_LiabNIMInt_SpreadCost_IncRatioCore_Cost_IncRatioOpCost_AssetAdj_PERTier1RatioTier2RatioCARCoreOpIncomeGrowthEPSGrowthBVPSGrowthAdv_GrowthLoanDepositsCashDepositsInvestmentDepositsIncLoanDepositsGrossNPANetNPAOwnersfund_total_SourceFixed_Assets_TAInventory_TRDividend_PR_NPDividend_PR_CPEarning_Retention_RatioCash_Earnings_Retention 递增 递减 1Price_BVReturn_SalesDebt_TAEVPriceSalesRatioEV_EBITACF_PerSharePCF_RATIOFCF_SharePFCF_RatioFCF_YieldSCF_RatioGPMSalesToTotalAssetsSalesToCurrentAssetsTotal_CAR_baseITI_CAR_baseITII_CAR_baseITotal_CARTI_CARTII_CARNPA_GrossNPA_NetNPA_AdvancesNetProfit_To_PBTPBT_To_PBITPBIT_To_SalesNetProfit_To_SalesNetSales_To_TotalAssetsReturn_On_AssetsAssets_To_EquityReturn_On_EquityInterest_To_DebtDebt_To_AssetsInterest_To_AssetsROE_After_InterestDividend_Payout_PerOtherIncome_To_NetWorthROA_After_InterestROE_Before_OtherIncROE_After_OtherIncROE_After_Tax_RateCredit_DepositInterestExpended_InterestEarnedInterestIncome_TotalFundsInterestExpended_TotalFundsNetInterestIncome_TotalFundsCASAInventory_TurnoverDebtors_TurnoverAdj_PEAdjusted_bvAdj_DPSNetworth_GrowthCE_GrowthGB_GrowthPBDT_GrowthPBIT_GrowthPBT_GrowthCP_GrowthExports_GrowthImports_GrowthMCap_GrowthEBIDTAMPBDTMLT_Debt_Equity_RatioROICTotal_car_bTI_CAR_bTII_CAR_bFLAG
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132777 AND `FinanceRatios`.`Year_end` = 202303 AND `FinanceRatios`.`Type` = \'C\'
132777 202303 C -8.33 -8.33 0.20 19.00 1025.78 150.11 24.70 6.78 5.99 -3.00 0.11 -0.36 -0.46 1.04 0.12 1.55 1.01 0.65 3.32 0.00 0.00 0.00 0.00 3.63 0.51 20.26 48.88 298.98 3.55 20.50 47.62 29.90 9.69 -98.88 -100.55 -100.55 -100.84 -100.84 0.00 2.71 2.71 8.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 60.50 -100.55 -22.98 0.00 0.00 0.00 0.00 0.00 0.00 0.00 99.98 3.03 0.54 0.00 0.00 0.00 -9490.09 3.63 6.78 0.01 475240.57 38.72 204.87 39.72 93.85 6.34 588.11 0.00 4.58 40.67 0.13 5.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.50 0.88 5.99 -3.00 1329.36 0.89 1.30 -0.46 758.29 19.35 0.10 -0.53 -228.21 2.93 0.78 1.02 3.95 -1.98 0.00 0.00 0.00 0.00 0.00 0.00 0.00 110.04 0.00 1025.78 19.00 -22.79 -16.68 42.79 9.02 -98.88 -99.01 -99.98 0.00 0.00 -17.11 41.45 40.67 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 205498 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
205498 202003 C 1119496.86 1119496.86 0.00 0.00 5042452.83 29.85 13.95 13.13 9.28 6.51 8.95 7.47 22.45 22.70 1.15 2.92 -34.71 0.34 69.39 95.35 117.50 0.00 0.00 0.00 0.00 0.26 1.68 1.99 0.43 0.00 -7.88 -3.30 -2.30 -7.06 -11.00 -11.00 -11.00 -11.00 1.06 0.95 0.48 3.42 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30.84 -11.00 2.30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 48.54 3.56 43.02 79.35 57.71 57.71 -6721.25 0.00 13.13 35.51 2852.60 0.00 1.64 0.00 0.00 0.00 0.00 0.00 9.69 11.73 1.14 98.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.70 0.71 9.28 6.51 356.24 14.99 3.01 22.45 12.35 183.11 4.39 22.16 9379.21 5.52 10.60 31.87 37.39 26.23 0.00 0.00 0.00 0.00 0.00 0.00 3.83 5.26 0.00 5042452.83 0.00 2.30 0.89 8.86 -9.78 -7.06 -17.01 -1.90 0.00 0.00 0.00 15.57 11.73 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 229365 AND `FinanceRatios`.`Year_end` = 202303 AND `FinanceRatios`.`Type` = \'C\'
229365 202303 C 154.55 154.55 154.70 4400.00 533498.76 36.66 63.55 86.93 86.93 55.06 55.06 0.05 0.06 0.08 0.00 0.28 0.01 3.62 93.21 0.00 0.00 0.00 0.00 0.00 0.00 -97.81 -112.52 -112.52 -0.05 0.00 -98.30 -19.34 10.33 10.33 356.87 -95.43 356.43 356.43 0.01 8.16 8.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -100.00 356.87 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 99.32 0.36 24.37 2844.45 2844.45 2844.45 -2744.16 0.00 86.93 0.65 -5551.60 1.03 -112.56 0.00 0.00 0.00 0.00 0.00 0.03 86.93 0.00 11.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.63 1.00 86.93 55.06 143.51 0.04 1.07 0.06 0.00 0.70 0.00 0.03 2846.89 0.01 0.04 0.05 0.06 0.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.92 0.00 533498.76 4400.00 7818.84 5975.56 0.00 428.27 10.33 428.27 356.87 0.00 0.00 0.00 86.93 86.93 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132616 AND `FinanceRatios`.`Year_end` = 202403 AND `FinanceRatios`.`Type` = \'C\'
132616 202403 C 1.23 1.23 1.28 34.00 31.77 79.30 26.81 39.02 37.94 7.85 8.16 1.92 2.66 12.00 0.24 1.05 0.62 0.95 19.86 0.00 0.00 92.05 88.56 3.56 30.04 6.06 15.41 15.54 2.31 7.23 0.00 -5.74 13.73 13.99 -69.49 -69.49 -69.49 -69.49 0.29 2.87 2.87 36.39 0.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1770.00 -69.49 -47.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 77.25 1.09 6.56 0.00 0.00 0.00 -2559.83 3.56 39.02 16.79 105727.80 7.67 15.41 -1.08 -104.56 0.94 120.56 0.01 -14.46 38.25 0.28 34.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.21 0.97 37.94 7.85 0.00 10.96 1.38 2.66 1.79 75.30 0.30 3.87 2764.68 6.17 10.66 14.75 20.91 4.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18.38 92.05 31.77 34.00 -47.66 -22.81 -2.73 10.81 13.99 11.04 -68.71 0.00 0.00 112.62 39.32 38.25 0.29 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132859 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'S\'
132859 202203 S -0.14 -0.14 10.67 245.00 922.65 143.01 -10.82 2.51 0.22 -0.09 7.21 -0.01 -0.02 0.47 0.13 0.71 0.21 1.40 311.85 0.00 0.00 0.00 95.97 1.11 23.93 3.41 34.75 135.88 0.36 6.92 17.06 -0.33 467.61 126.26 98.87 98.87 98.87 99.43 0.04 3.26 3.26 1.09 0.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -18.14 99.43 1.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 96.22 2.43 36.88 0.00 0.00 0.00 -2196.42 1.11 2.51 2.62 210859.07 8.54 34.75 -380.65 -2.69 -375.51 -2.73 -0.37 -0.39 7.52 0.11 26.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.43 0.09 0.22 -0.09 279.39 0.27 1.65 -0.02 9.34 48.76 0.24 -0.02 0.00 3.31 0.02 0.04 3.35 -1.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.17 0.00 922.65 245.00 102.48 57.25 -56.47 237.54 126.26 101.76 625.67 0.00 0.00 19.15 9.82 7.52 0.03 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132760 AND `FinanceRatios`.`Year_end` = 201903 AND `FinanceRatios`.`Type` = \'C\'
132760 201903 C 0.05 0.05 0.07 1.50 123.11 28.70 0.00 0.00 0.00 0.00 0.00 0.03 0.04 0.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2642.59 1872.05 1.13 1.08 0.00 1418.01 1816.27 1.05 0.00 -100.00 -100.01 -99.81 -99.81 -99.78 -99.78 -99.78 -99.78 0.09 1.32 1.23 22.06 0.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -99.90 -99.78 -13.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 91.86 0.00 0.00 0.00 0.00 0.00 -1920.20 1.13 0.00 7.64 44879.93 0.00 1418.01 -5.70 -24.37 -5.32 -26.14 -0.04 0.00 0.00 0.00 67.87 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.71 0.95 0.00 0.00 0.00 0.00 1.53 0.00 0.03 75.90 0.00 0.04 2851.71 0.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2642.59 123.11 1.50 -13.77 -45.76 -51.34 -99.81 -99.81 -99.80 -99.80 0.00 -100.00 -4.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 228173 AND `FinanceRatios`.`Year_end` = 202403 AND `FinanceRatios`.`Type` = \'C\'
228173 202403 C 4.72 4.72 5.19 59.28 34.63 21.15 18.15 18.85 18.72 14.76 16.22 12.27 13.71 17.51 0.83 4.44 1.60 0.23 60.72 0.00 0.00 0.00 0.00 0.00 0.00 -0.15 -0.76 -0.82 -0.14 0.00 -1.30 5.68 -41.79 -42.49 -41.61 -41.61 -41.61 -97.66 0.00 8.69 8.69 147.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.31 -97.66 -95.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 15.00 16.07 0.00 0.00 0.00 -1042.01 0.00 18.85 0.00 -431.86 0.00 -2.30 4.03 0.00 2.15 0.00 0.00 7.95 20.18 0.84 1.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.79 0.99 18.72 14.76 1512.01 15.87 1.12 13.71 0.00 10.70 0.11 13.63 1255.42 1.99 15.76 17.61 19.61 15.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6.01 0.00 34.63 59.28 1.12 -2.50 12.23 -41.95 -42.49 -42.67 -40.78 0.00 0.00 0.00 20.31 20.18 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132859 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'C\'
132859 202203 C 1460.35 1460.35 29.66 245.00 1868.26 91.80 3.47 1.99 1.14 0.09 3.80 0.04 0.06 1.14 0.42 1.77 0.75 0.57 103.27 0.00 0.00 0.70 34.52 0.55 23.93 0.33 4.05 16.42 0.10 1.31 25.44 46.11 76.87 183.55 105.23 105.23 1714.50 807.25 0.04 3.14 3.14 2.35 0.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -21.35 102.61 87.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 96.20 3.28 18.88 0.00 0.00 0.00 -726.09 0.55 1.99 2.90 106625.33 1.62 5.74 118.07 8.67 67.14 15.25 0.07 6.61 7.22 0.31 25.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.08 0.57 1.14 0.09 603.23 0.61 1.57 0.06 8.96 35.45 0.26 0.04 16.78 1.92 0.35 0.55 2.47 0.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.53 0.70 1868.26 245.00 274.65 118.34 -36.85 107.20 183.55 133.09 111.06 0.00 0.00 19.15 8.06 7.22 0.03 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 123716 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'C\'
123716 202203 C -0.69 -0.69 0.13 0.90 71.91 51.87 0.89 1.07 -6.60 -3.18 0.60 -0.44 -0.95 0.28 0.14 2.31 0.28 0.43 42.75 1636.04 0.00 0.00 1048.62 1.90 0.66 6.46 95.42 602.06 1.60 6.31 -8.36 -63.99 -34.09 -82.87 -509.45 -509.45 -509.93 -510.08 0.22 1.86 0.51 0.14 0.12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25.19 -509.44 -1.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 81.99 4.15 573.56 0.00 0.00 0.00 -590.89 1.90 1.07 8.73 143266.91 9.68 133.20 -8.34 -16.39 -7.38 -18.51 -0.05 -2.60 -0.90 0.12 2.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.48 -6.15 -6.60 -3.18 421.94 0.13 2.15 -0.95 10.52 132.56 0.92 -0.97 -130.60 1.77 -0.79 -1.70 0.07 0.03 0.00 0.00 0.00 0.00 0.00 0.00 0.22 8.54 0.00 71.91 0.90 -1.96 37.19 -1.49 -121.75 -82.87 -4977.77 -87.43 0.00 0.00 3.52 6.77 -0.90 0.07 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 111147 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
111147 202003 C -0.45 -0.45 0.25 1.50 31.29 29.05 -1.30 1.95 -2.04 -1.44 0.81 -0.97 -1.40 1.50 0.67 5.87 1.50 0.17 73.39 24.31 0.00 0.00 52.80 0.43 11.15 -0.07 -1.69 -3.65 -0.06 0.43 52.09 55.10 -11.21 -46.67 -568.72 -568.72 -568.77 -568.72 0.25 2.69 2.50 0.49 0.59 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14.20 -568.72 -6.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 79.83 7.86 17.68 0.00 0.00 0.00 -488.80 0.43 1.95 18.28 -258.97 0.70 -1.69 2.70 4.98 1.42 9.48 0.11 11.62 0.22 0.73 31.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.71 -1.04 -2.04 -1.44 3168.65 1.42 1.43 -1.40 15.84 44.44 2.90 -1.47 -330.94 5.49 -1.48 -2.12 3.37 2.39 0.00 0.00 0.00 0.00 0.00 0.00 15.01 4.97 0.00 31.29 1.50 -6.89 -13.21 43.45 -82.35 -46.67 -1298.22 -41.44 -59.19 0.00 -50.19 4.21 0.22 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 126881 AND `FinanceRatios`.`Year_end` = 202303 AND `FinanceRatios`.`Type` = \'C\'
126881 202303 C -3.54 -3.54 0.34 2.00 675.79 211.59 -9.33 6.96 6.74 -7.52 0.54 -0.65 -0.70 0.65 0.09 0.54 0.18 1.86 53.18 0.00 0.00 0.00 511.74 0.26 1.14 -2.18 -7.43 -31.27 -0.20 2.78 80.99 76.99 280.59 127.54 70.67 70.67 69.33 69.33 0.00 5.66 5.66 31.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 33.51 70.67 0.57 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 1.02 15.21 0.00 0.00 0.00 -484.68 0.26 6.96 0.00 -63095.30 7.84 -14.48 15.35 11.41 14.31 12.23 0.08 4.10 29.06 0.08 1.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -1.12 0.97 6.74 -7.52 137.27 0.59 1.08 -0.70 0.00 12.26 0.02 -0.70 -56.51 3.60 0.57 0.62 4.21 -4.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6.86 0.00 675.79 2.00 0.57 4.09 5.03 277.46 127.54 126.51 102.55 0.00 0.00 -34.74 29.28 29.06 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 106414 AND `FinanceRatios`.`Year_end` = 202403 AND `FinanceRatios`.`Type` = \'C\'
106414 202403 C -7.99 -7.99 0.25 1.25 95.63 -143.18 8.31 2.25 -2.94 -7.15 0.21 -4.01 -8.30 1.58 0.56 0.93 4.90 1.08 60.61 118.27 155.24 0.00 615.28 1.58 0.83 1.52 12.84 67.47 1.21 1.30 -4.08 53.28 48.17 125.23 54.81 54.81 54.88 54.88 0.48 1.35 0.90 0.43 0.30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -18.47 54.84 -8.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 67.61 1.28 46.84 0.00 0.00 0.00 -407.99 1.58 2.25 23.78 50959.24 2.11 15.79 36.48 4.15 4.92 30.77 0.03 3.19 6.64 0.60 58.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.43 -1.31 -2.94 -7.15 133.27 1.36 2.07 -8.30 13.17 77.83 3.13 -8.34 -15.65 4.09 -1.77 -3.67 0.42 1.01 0.00 0.00 0.00 0.00 0.00 0.00 3.09 6.02 0.00 95.63 1.25 -8.59 -13.05 14.34 311.00 125.23 80.76 102.86 0.00 0.00 41.56 11.83 6.64 0.14 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 109488 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'C\'
109488 202103 C -1.64 -1.64 1.01 5.00 232.43 174.94 -10.48 2.50 2.19 -1.64 1.01 -0.58 -0.71 1.00 0.35 2.12 0.69 0.47 69.19 240.72 64.74 0.00 504.67 2.20 0.98 5.10 90.05 204.25 2.09 5.11 -36.72 -159.34 16.28 32.26 -171.35 -171.35 -171.35 -171.35 0.05 4.16 3.02 8.06 0.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -65.88 -171.35 -0.27 0.00 0.00 0.00 0.00 0.00 0.00 0.00 95.31 3.06 69.27 0.00 0.00 0.00 -392.94 2.20 2.50 4.04 9981.77 2.96 99.05 29.89 17.13 32.03 15.98 0.06 3.35 5.35 0.35 19.88 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.75 0.88 2.19 -1.64 306.36 0.88 1.22 -0.71 2.71 19.28 0.11 -0.71 -304.54 6.96 0.77 0.95 7.90 -5.92 0.00 0.00 0.00 0.00 0.00 0.00 1.52 5.28 0.00 232.43 5.00 -0.27 -0.91 5.03 35.09 32.26 123.08 -79.44 0.00 -73.47 302.75 5.66 5.35 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 117370 AND `FinanceRatios`.`Year_end` = 201003 AND `FinanceRatios`.`Type` = \'C\'
117370 201003 C -1.31 -1.31 0.13 0.60 12.22 -73.37 3.22 2.00 -2.56 -4.44 0.44 -4.15 -9.92 2.56 0.94 1.06 1.66 0.95 74.90 106.47 60.71 0.00 93.74 1.00 4.93 0.71 10.33 35.47 0.80 0.41 14.90 -55.16 -34.74 -67.62 -350.89 -350.89 -350.89 -350.90 1.14 3.11 2.13 0.44 1.15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 36.64 -350.89 -14.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 46.73 3.07 50.75 -45.77 462.54 462.54 -362.54 1.00 2.00 38.90 97716916.00 0.56 10.33 1.22 9.99 -2.69 -4.53 -0.22 24.27 2.32 0.83 32.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.73 -1.28 -2.56 -4.44 313.69 1.65 2.39 -9.92 9.68 63.48 3.77 -10.77 -45.77 8.86 -2.11 -5.05 3.81 6.61 0.00 0.00 0.00 0.00 0.00 0.00 3.43 4.87 0.00 12.22 0.60 -14.01 30.91 14.53 -67.84 -67.62 -189.82 -92.83 0.00 -0.08 11.56 6.88 2.32 0.93 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 205479 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'C\'
205479 202103 C 697.19 697.19 766.88 3090.00 1334.25 30.72 26.40 26.74 26.67 18.48 20.32 18.44 27.56 39.88 1.00 2.55 130.32 0.39 12.56 19.72 267.18 0.00 0.00 0.00 0.00 -0.24 -0.70 -0.75 -0.57 0.00 20.49 39.32 20.79 40.95 32.15 32.15 32.15 32.15 0.00 1.02 0.84 375.87 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 67.74 32.15 -64.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 2.45 10.88 0.00 0.00 0.00 -302.93 0.00 32.01 0.00 -195314.35 0.08 -0.71 931.61 0.00 902.85 0.00 0.00 3.38 28.51 1.38 84.12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.69 1.00 31.93 22.12 1320.12 36.99 1.49 27.56 0.00 206.09 0.10 52.25 443.21 6.18 36.90 55.14 61.32 42.49 0.00 0.00 0.00 0.00 0.00 0.00 18.51 29.05 0.00 1334.25 3090.00 -64.19 -43.60 6.34 20.71 40.95 40.89 32.12 -59.12 0.00 0.00 28.58 28.51 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 100660 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
100660 202003 C 5.50 5.50 10.38 40.00 107.47 69.52 19.55 9.28 9.09 2.77 5.23 1.72 4.71 15.76 0.62 3.34 4.47 0.30 11.96 52.62 106.45 226.34 119.94 11.59 3.21 6.21 27.18 64.12 10.99 6.54 3.08 9.40 4.71 -54.32 -79.07 -79.07 -79.07 -79.07 0.00 1.74 1.26 49.26 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1042.97 -79.07 -14.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 99.99 4.26 18.08 0.00 0.00 0.00 -285.27 11.59 9.68 0.01 2001225.58 13.82 50.69 28.95 43.01 3.63 342.62 0.00 6.57 21.71 1.11 45.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.30 0.98 9.48 2.89 456.09 10.32 2.73 4.71 3579.38 73.40 0.21 5.12 727.03 4.34 10.12 27.65 31.99 9.75 0.00 0.00 0.00 0.00 0.00 0.00 6.94 30.53 226.34 107.47 40.00 -14.92 -61.27 159.79 3.89 -54.32 -55.21 -64.40 0.00 23.40 -4.20 21.90 21.71 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 130879 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'C\'
130879 202203 C -0.36 -0.07 0.01 0.10 79.09 -17.80 9.91 6.34 -3.32 -3.91 0.04 -1.56 -3.52 3.04 0.40 5.14 0.77 0.19 5.57 1.26 990.05 0.00 4530.27 1.58 0.08 2.54 24.64 40.14 1.00 1.83 66.42 -2.15 1.95 -13.91 -440.06 -440.06 -128.82 -128.82 1.18 1.85 1.85 0.66 0.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 110.90 -440.06 9.53 0.00 0.00 0.00 0.00 0.00 0.00 0.00 45.80 6.82 1.97 0.00 0.00 0.00 -262.57 1.58 6.34 44.93 134804.55 1.85 24.74 -40.32 -3.10 -52.21 -2.39 -0.42 -1.69 0.67 0.33 41.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.18 -0.52 -3.32 -3.91 913.49 2.07 2.26 -3.52 7.03 134.09 3.16 -3.36 -28.08 0.36 -1.08 -2.45 -2.10 -2.47 0.00 0.00 0.00 0.00 0.00 0.00 288.89 65.50 0.00 15.82 0.02 9.53 56.06 21.58 -87.91 -13.91 -219.06 -98.97 0.00 0.00 -13.71 10.32 0.67 0.19 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 214179 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'C\'
214179 202103 C 3.76 3.76 5.45 18.93 23.93 28.28 28.16 21.23 19.15 13.74 19.93 10.63 16.88 20.63 0.77 1.21 4.30 0.83 75.81 58.47 96.25 0.00 0.00 0.00 0.00 0.58 2.05 2.74 0.52 0.00 50.90 82.03 78.73 -19.49 -40.29 -40.29 -41.03 -95.09 0.27 1.80 1.13 10.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25.18 -95.09 -90.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 79.00 1.29 46.13 0.00 0.00 0.00 -247.53 0.00 21.23 16.59 9100.59 25.13 0.78 2.49 0.00 -1.99 0.00 0.00 10.97 26.23 0.71 42.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.72 0.90 19.15 13.74 310.67 15.13 1.59 16.88 8.92 70.38 1.48 15.62 504.10 0.17 13.65 21.68 21.85 15.67 0.00 0.00 0.00 0.00 0.00 0.00 6.24 4.81 0.00 23.93 18.93 16.48 18.76 19.03 84.99 -19.49 -22.49 -26.99 62.91 -1.89 0.00 28.31 26.23 0.14 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 111147 AND `FinanceRatios`.`Year_end` = 201903 AND `FinanceRatios`.`Type` = \'C\'
111147 201903 C 0.10 0.10 0.43 1.50 33.60 -81.36 -4.42 5.57 0.26 0.47 2.11 0.19 0.29 2.58 0.40 5.83 0.85 0.17 176.09 74.04 0.00 279.21 62.07 0.80 5.56 0.52 7.28 9.42 0.26 1.31 -33.06 64.01 34.79 -96.58 -99.59 -99.59 -99.59 -99.59 0.25 2.47 2.37 1.05 0.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -59.04 -99.59 0.42 0.00 0.00 0.00 0.00 0.00 0.00 0.00 79.96 7.30 54.54 0.00 0.00 0.00 -244.81 0.80 5.57 16.91 1253.11 0.69 7.28 3.18 8.49 2.27 11.91 0.08 6.49 1.90 0.41 35.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.81 0.05 0.26 0.47 2735.29 2.31 1.55 0.29 13.02 52.70 2.20 0.26 1551.18 7.09 0.11 0.17 7.26 13.16 0.00 0.00 0.00 0.00 0.00 0.00 4.93 2.07 279.21 33.60 1.50 0.42 -7.68 63.67 124.90 -96.58 -99.83 -98.19 -24.75 0.00 -15.49 7.21 1.90 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 292026 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
292026 202003 C -0.28 -0.06 0.03 0.50 35.02 -410.21 -0.51 1.37 -0.38 -1.93 1.02 -0.67 -0.78 0.52 0.35 1.48 0.71 0.67 175.93 98.29 90.80 0.00 235.55 0.99 1.45 2.57 59.44 187.59 0.96 2.41 -28.09 -119.87 -68.59 -87.64 -137.92 -137.92 -137.92 -137.92 0.10 4.35 3.67 0.78 0.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7.39 -137.92 -2.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 91.30 2.55 74.84 0.00 0.00 0.00 -241.37 0.99 1.37 7.89 178244433.00 4.46 40.84 1.79 12.84 1.77 13.01 0.08 7.99 2.57 0.34 20.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.10 -0.28 -0.38 -1.93 254.61 0.46 1.16 -0.78 7.49 18.08 0.59 -0.79 -181.22 1.97 -0.13 -0.15 1.83 9.32 0.00 0.00 0.00 0.00 0.00 0.00 3.71 2.07 0.00 7.78 0.11 -2.07 5.48 -6.00 -78.78 -87.64 -104.00 -86.81 0.00 0.00 -0.72 4.32 2.57 0.03 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 100660 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'C\'
100660 202203 C 100.04 100.04 26.50 90.00 157.19 51.12 21.20 21.73 21.67 10.59 12.49 10.11 18.39 37.72 0.95 6.03 1.79 0.17 21.37 54.91 140.69 16.62 62.75 10.58 5.41 7.84 30.67 32.89 9.65 8.59 12.05 27.37 18.19 70.71 32.55 32.55 373.19 373.19 0.00 2.18 1.87 391.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -43.48 32.55 80.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 9.95 22.57 0.00 0.00 0.00 -239.60 10.58 23.83 0.00 2568686.30 7.42 30.25 47.86 34.75 31.56 52.70 0.02 4.04 23.25 0.80 32.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.49 1.00 23.77 11.62 1111.40 17.28 1.82 18.39 0.00 74.43 0.04 14.30 89.97 2.85 17.24 31.35 34.19 16.71 0.00 0.00 0.00 0.00 0.00 0.00 6.65 17.08 16.62 157.19 90.00 80.14 50.09 -1.50 18.50 70.71 71.60 22.71 0.00 -22.33 15.45 23.30 23.25 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132515 AND `FinanceRatios`.`Year_end` = 202303 AND `FinanceRatios`.`Type` = \'C\'
132515 202303 C 14.79 14.79 21.71 70.00 138.86 26.69 14.95 14.09 13.70 10.05 14.75 6.91 8.89 12.46 0.69 1.91 1.42 0.52 83.99 0.00 0.00 12.23 8.34 1.30 38.68 1.16 5.81 8.21 1.23 1.23 -5.58 -45.38 -39.36 -49.71 -51.39 -51.39 -51.39 -51.39 0.00 3.48 3.48 37.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 26.52 -51.39 -28.45 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 4.14 24.17 0.00 0.00 0.00 -222.44 1.30 14.09 0.00 1015.72 1.85 6.16 6.83 26.50 7.83 23.12 0.04 21.56 19.53 0.80 17.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.73 0.97 13.70 10.05 503.77 11.32 1.29 8.89 0.00 35.24 0.31 10.65 473.28 5.26 11.01 14.16 19.42 14.24 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.35 12.23 138.86 70.00 -28.45 -25.20 4.63 -39.97 -49.71 -50.54 -42.14 0.00 -4.39 -51.19 19.91 19.53 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 225142 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'C\'
225142 202103 C 3775.47 3775.47 72.39 215.00 31660.18 34.52 3.64 6.08 6.04 3.95 4.06 0.23 0.24 0.36 0.06 46.16 1.94 0.02 15.04 26.38 2.83 3.67 191.33 0.44 1.55 7.36 119.01 121.18 0.41 7.77 7.12 47.58 22.94 23.63 19.71 19.71 68.57 68.57 0.00 15.65 13.81 151.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -89.85 19.71 12.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 217.55 10.56 0.00 0.00 0.00 -197.01 0.44 6.08 0.00 40318.50 6.90 119.01 -109.89 -126.04 -70.69 -195.93 -0.01 -16.21 6.15 0.06 5.15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.65 0.99 6.04 3.95 0.00 0.34 1.00 0.24 0.00 0.21 0.00 0.22 5.69 0.14 0.34 0.34 0.48 0.32 0.00 0.00 0.00 0.00 0.00 0.00 13.83 24.27 3.67 31660.18 215.00 12.92 12.26 -16.78 32.52 23.63 33.52 18.83 0.00 0.00 52.21 6.19 6.15 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 238839 AND `FinanceRatios`.`Year_end` = 201503 AND `FinanceRatios`.`Type` = \'C\'
238839 201503 C 6.77 6.77 7.77 22.40 49.12 11.95 6.25 18.36 18.36 16.16 18.55 8.18 11.42 12.97 0.51 1.58 1.39 0.63 155.34 0.00 1184.25 0.00 0.00 0.00 0.00 -0.22 -0.98 -1.18 -0.18 0.00 -57.93 -69.97 -49.74 -49.90 -35.49 -35.49 -35.49 -35.49 0.00 1.83 1.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -35.49 -29.21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 52.37 17.25 331.03 288.39 288.39 -188.39 0.00 18.36 0.00 -27624005.00 0.00 -2.19 21.41 0.00 26.00 0.00 0.00 1.96 22.16 0.51 54.17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 1.00 18.36 16.16 5236.91 9.30 1.40 11.42 0.00 74.75 0.00 13.78 331.03 13.56 9.30 12.99 26.55 23.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.35 0.00 49.12 22.40 -29.21 -0.30 -29.73 -49.74 -49.90 -49.90 -42.92 0.00 0.00 0.00 22.16 22.16 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 225142 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
225142 202003 C 2239.76 2239.76 60.92 175.00 28037.80 26.97 2.64 5.26 4.84 3.54 3.66 0.22 0.23 0.34 0.06 39.93 1.99 0.03 18.64 37.88 5.15 4.06 149.36 0.32 1.92 5.00 92.68 94.90 0.30 5.47 -22.84 -22.47 -6.38 -6.75 -2.47 -2.47 3.65 3.65 0.00 4.80 4.16 12.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -36.25 -2.47 17.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 145.14 13.00 0.00 0.00 0.00 -187.26 0.32 5.26 0.00 25539.65 10.22 92.68 260.71 34.90 297.88 30.55 0.03 6.38 4.97 0.06 3.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.73 0.92 4.84 3.54 0.00 0.31 1.01 0.23 0.00 0.80 0.02 0.21 7.81 0.16 0.28 0.29 0.45 0.33 0.00 0.00 0.00 0.00 0.00 0.00 9.64 19.58 4.06 28037.80 175.00 17.37 17.55 2.36 -2.50 -6.75 -2.83 -2.03 0.00 0.00 -23.42 5.39 4.97 0.00 0.00 0.00 0.00 0.00 A
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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