将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 18014 行, 查询花费 0.0453 秒。) [TII_CAR_baseI: 1.86... - 0.00...]
SELECT * FROM `FinanceRatios` ORDER BY `TII_CAR_baseI`  DESC
[编辑内嵌] [ 编辑 ] [ 解析 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_RetentionPrice_BVReturn_SalesDebt_TAEVPriceSalesRatioEV_EBITACF_PerSharePCF_RATIOFCF_SharePFCF_RatioFCF_YieldSCF_RatioGPMSalesToTotalAssetsSalesToCurrentAssetsTotal_CAR_baseITI_CAR_baseITII_CAR_baseI 递减 递增 1Total_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` = 100010 AND `FinanceRatios`.`Year_end` = 201803 AND `FinanceRatios`.`Type` = \'S\'
100010 201803 S 65.39 65.39 65.69 20.00 383.54 16.91 90.35 90.28 32.42 26.93 27.06 2.98 21.10 10.43 0.11 46.18 -0.57 0.02 0.96 0.00 0.00 27.90 27.77 4.76 1.10 15.34 16.96 16.99 1.57 7.51 22.88 16.08 15.97 16.02 47.25 47.25 39.58 39.58 4.97 0.16 0.16 1.56 1.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 12.46 39.58 53.89 0.00 0.00 0.00 0.00 0.00 0.00 0.80 16.74 63.13 0.25 0.00 0.00 0.00 69.55 4.76 90.28 80.41 623981.82 11.21 16.96 -333.58 -5.47 32.41 56.30 0.02 -0.73 32.54 0.10 526.82 19.16 17.30 1.86 0.00 0.00 0.00 4077.24 2919.81 0.80 0.83 0.36 32.42 26.93 6360.57 9.24 7.08 21.10 7.36 129.72 5.92 16.73 30.58 0.03 3.32 23.47 23.50 19.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 382.18 27.90 383.54 20.00 62.34 17.88 -37.30 22.78 16.02 22.96 46.81 0.00 0.00 28.10 90.40 32.54 3.62 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 100010 AND `FinanceRatios`.`Year_end` = 201903 AND `FinanceRatios`.`Type` = \'S\'
100010 201903 S 55.96 55.96 56.34 21.00 442.98 26.57 94.70 94.62 30.26 22.22 22.37 2.25 13.71 9.90 0.10 61.87 -0.70 0.02 1.22 0.00 0.00 35.16 34.92 4.44 1.07 16.22 17.12 17.15 1.54 7.81 6.53 11.66 11.69 11.66 -12.11 -12.11 -14.43 -14.43 4.80 0.24 0.24 1.47 1.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 18.49 -14.43 15.50 0.00 0.00 0.00 0.00 0.00 0.00 0.84 17.23 66.55 0.43 0.00 0.00 0.00 62.73 4.44 94.62 79.97 703278.99 10.81 17.12 -239.13 -8.23 42.07 46.76 0.02 -1.05 30.42 0.09 337.77 19.08 17.54 1.54 0.00 0.00 0.00 4835.08 3431.76 0.84 0.73 0.32 30.26 22.22 6728.66 8.96 6.09 13.71 7.62 105.03 6.09 12.39 37.53 0.04 2.86 17.44 17.48 12.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 298.63 35.16 442.98 21.00 18.64 15.17 6.33 -0.40 11.66 -0.54 -11.90 0.00 0.00 10.76 94.77 30.42 3.70 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 100010 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'S\'
100010 202003 S 102.59 102.59 103.45 21.00 491.61 12.68 87.76 87.55 34.65 30.25 30.50 3.62 22.02 10.84 0.12 51.98 -1.01 0.02 1.30 0.00 0.00 15.89 15.76 3.32 1.29 11.88 13.54 13.57 1.34 4.81 35.51 25.57 25.54 25.38 84.48 84.48 83.35 83.35 4.92 0.36 0.36 1.65 1.48 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11.40 83.35 10.98 0.00 0.00 0.00 0.00 0.00 0.00 1.49 16.89 43.54 0.39 0.00 0.00 0.00 79.70 3.32 87.55 80.21 698078.04 7.39 13.54 -252.98 -6.45 94.12 17.32 0.06 -1.34 34.90 0.11 220.03 17.59 16.44 1.15 0.00 0.00 0.00 8915.88 6648.81 1.49 0.87 0.40 34.65 30.25 5956.69 9.84 6.07 22.02 7.41 105.37 5.95 20.57 20.47 0.03 3.89 23.66 23.69 20.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 281.78 15.89 491.61 21.00 11.66 14.10 112.97 55.47 25.38 55.13 84.73 0.00 0.00 -16.61 87.80 34.90 3.93 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 100010 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'S\'
100010 202103 S 66.67 66.67 67.55 23.00 594.82 18.82 90.62 90.35 30.77 24.98 25.31 2.21 12.50 8.24 0.09 30.02 -0.58 0.03 1.46 0.00 0.00 37.48 36.99 4.20 0.92 18.51 20.41 20.48 1.57 9.36 -18.03 -15.36 -15.35 -15.41 -32.32 -32.32 -35.01 -35.01 4.11 0.20 0.20 1.52 0.98 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.69 -35.01 20.99 0.00 0.00 0.00 0.00 0.00 0.00 1.15 19.56 35.51 0.32 0.00 0.00 0.00 65.95 4.20 90.35 77.99 891018.38 8.30 20.41 -157.64 -15.85 70.11 35.64 0.03 -1.69 31.10 0.09 422.34 22.17 21.45 0.72 0.00 0.00 0.00 11615.77 5558.77 1.15 0.81 0.34 30.77 24.98 4881.29 7.69 5.66 12.50 6.50 94.98 5.07 11.01 34.50 0.02 2.62 14.81 14.83 12.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 249.84 37.48 594.82 23.00 26.02 8.31 8.54 -26.95 -15.41 -27.20 -31.99 0.00 0.00 59.63 90.68 31.10 3.24 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 100010 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'S\'
100010 202203 S 75.80 75.80 76.75 30.00 654.24 20.32 92.19 91.90 35.96 28.65 29.01 2.28 12.17 7.53 0.08 26.61 -0.46 0.04 1.27 0.00 0.00 31.51 31.12 3.65 1.26 19.43 21.06 21.15 1.46 9.03 -0.40 1.33 1.34 1.32 14.26 14.26 13.68 13.68 4.21 0.07 0.07 1.64 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 -6.48 13.68 9.99 0.00 0.00 0.00 0.00 0.00 0.00 1.06 19.18 33.21 0.37 0.00 0.00 0.00 60.91 3.65 91.90 78.16 931962.40 8.37 21.06 -244.95 -9.75 72.56 32.92 0.03 -1.08 36.32 0.08 1200.14 22.82 22.24 0.58 0.00 0.00 0.00 12875.04 5883.98 1.06 0.80 0.39 35.96 28.65 4465.56 6.89 5.33 12.17 5.37 91.90 4.20 11.39 39.58 0.03 2.70 14.39 14.42 11.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00 287.14 31.51 654.24 30.00 10.54 12.96 15.94 16.33 1.32 16.41 14.18 0.00 0.00 -3.93 92.26 36.32 3.40 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 131840 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
131840 202003 C -0.36 -0.36 -0.36 0.00 20.65 0.00 0.00 0.00 0.00 0.00 0.00 -1.63 -1.77 -1.68 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.31 -29.43 0.50 0.00 0.00 -22.31 -21.58 41.30 41.52 41.52 42.24 42.24 0.05 13.13 13.13 -295.05 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 -72.06 41.52 -1.37 0.00 0.00 0.00 0.00 0.00 0.00 0.00 94.93 0.00 0.00 0.00 0.00 0.00 100.00 0.00 0.00 4.92 1649.70 0.00 -2.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 1.09 0.00 0.11 7.75 0.01 -1.79 0.00 0.01 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 20.65 0.00 -1.37 -1.53 0.00 -20.18 41.30 41.52 -20.18 0.00 0.00 -100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 131840 AND `FinanceRatios`.`Year_end` = 202303 AND `FinanceRatios`.`Type` = \'C\'
131840 202303 C -0.14 -0.14 -0.14 0.00 20.22 0.00 0.00 0.00 0.00 0.00 0.00 -0.69 -0.75 -0.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -77.05 -72.69 0.51 0.00 0.00 -133.30 1.60 2.94 2.04 2.04 1.30 1.32 0.05 11.20 11.20 -75.97 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 233.33 2.04 -0.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 94.83 0.00 0.00 0.00 0.00 0.00 100.00 0.00 0.00 5.05 1656.57 0.00 -6.09 -0.01 0.00 -0.01 0.00 0.00 0.00 0.00 0.00 5.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.01 0.00 0.00 0.00 0.00 1.08 0.00 0.18 9.24 0.01 -0.75 0.00 1.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 20.22 0.00 -0.71 -1.10 -87.33 0.64 2.94 2.04 0.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 131840 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'C\'
131840 202103 C -0.14 -0.14 -0.14 0.00 20.51 0.00 0.00 0.00 0.00 0.00 0.00 -0.66 -0.72 -0.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 -80.96 -74.99 0.50 0.00 0.00 54.31 62.43 60.61 59.82 59.82 61.18 61.18 0.05 13.12 13.12 -42.46 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 173.68 59.82 -0.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 94.90 0.00 0.00 0.00 0.00 0.00 100.00 0.00 0.00 4.95 1655.73 0.00 -6.36 -0.07 0.00 -0.04 0.00 0.00 0.00 0.00 0.00 6.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.02 0.00 0.00 0.00 0.00 1.09 0.00 0.31 7.76 0.02 -0.72 0.00 0.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 0.00 20.51 0.00 -0.68 -0.70 -0.67 61.61 60.61 59.82 61.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 131840 AND `FinanceRatios`.`Year_end` = 202403 AND `FinanceRatios`.`Type` = \'C\'
131840 202403 C -0.41 -0.41 -0.41 0.00 19.81 0.00 0.00 0.00 0.00 0.00 0.00 -1.95 -2.08 -1.97 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.66 -26.48 0.53 0.00 0.00 -17.90 -193.49 -178.81 -175.36 -175.36 -185.74 -185.80 0.06 15.06 15.06 -1588.50 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 -86.67 -175.36 -2.04 0.00 0.00 0.00 0.00 0.00 0.00 0.00 94.73 0.00 0.00 0.00 0.00 0.00 100.00 0.00 0.00 5.28 1682.34 0.00 -2.48 -0.44 0.00 -0.44 0.00 0.00 0.00 0.00 0.00 5.59 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 1.07 0.00 0.02 6.80 0.00 -2.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 0.00 0.00 0.00 19.81 0.00 -2.04 -4.30 61.59 -189.63 -178.81 -175.36 -189.63 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 131840 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'C\'
131840 202203 C -0.15 -0.15 -0.14 0.00 20.37 0.00 0.00 0.00 0.00 0.00 0.00 -0.70 -0.76 -0.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -76.21 -70.92 0.51 0.00 0.00 8.31 -6.85 -6.34 -4.29 -4.29 -4.57 -4.57 0.05 13.22 13.22 -260.89 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 -82.69 -4.29 -0.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 94.87 0.00 0.00 0.00 0.00 0.00 100.00 0.00 0.00 4.99 1665.17 0.00 -6.39 -0.07 0.00 -0.06 0.00 0.00 0.00 0.00 0.00 6.18 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 1.08 0.00 0.05 7.69 0.00 -0.76 0.00 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 0.00 20.37 0.00 -0.71 -0.81 0.68 -4.63 -6.34 -4.29 -4.63 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132608 AND `FinanceRatios`.`Year_end` = 201003 AND `FinanceRatios`.`Type` = \'C\'
132608 201003 C 9.54 9.54 12.25 3.00 49.87 36.34 43.53 40.33 35.07 22.33 28.66 9.40 19.45 21.17 0.42 0.70 1.63 1.42 71.33 49.92 101.59 16.16 12.59 3.09 1.95 3.65 7.82 9.05 1.97 3.61 6.89 50.06 37.67 40.17 62.35 62.35 64.11 64.11 0.59 2.35 2.13 7.67 0.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -32.79 64.13 4.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 63.03 0.79 29.56 0.00 0.00 0.00 75.50 3.09 40.33 28.71 377827.21 0.05 7.82 21.13 7.29 18.22 8.46 0.12 2.02 41.41 0.42 10.55 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.64 0.87 35.07 22.33 125.20 16.91 2.07 19.45 7.68 57.67 2.20 19.07 31.45 2.68 14.71 30.42 33.09 21.07 0.00 0.00 0.00 0.00 0.00 0.00 7.31 5.12 16.16 49.87 3.00 3.39 0.68 3.94 58.81 40.17 67.40 51.85 0.00 -40.76 221.69 46.66 41.41 0.59 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132608 AND `FinanceRatios`.`Year_end` = 200803 AND `FinanceRatios`.`Type` = \'C\'
132608 200803 C 12.40 12.40 13.63 3.00 44.10 35.18 61.19 62.26 52.35 33.94 37.29 15.19 32.13 30.76 0.45 1.20 0.66 0.83 136.24 24.76 70.29 13.21 12.02 3.71 1.83 4.50 6.87 7.24 1.93 4.48 52.28 106.22 95.74 96.76 84.06 84.06 79.67 79.67 0.77 8.75 8.40 6.29 0.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 145.18 79.66 30.11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 54.44 1.28 34.67 24.35 22.16 22.16 77.98 3.71 62.26 38.58 403092.32 0.06 6.87 22.28 7.35 15.13 10.83 0.09 1.64 55.71 0.38 10.27 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.65 0.84 52.35 33.94 146.20 23.78 2.12 32.13 9.80 14.98 3.78 25.20 24.19 3.29 19.99 42.29 45.58 29.55 0.00 0.00 0.00 0.00 0.00 0.00 14.74 2.68 13.21 44.10 3.00 33.30 41.99 8.05 88.96 96.76 89.67 83.55 0.00 -23.36 8.16 65.61 55.71 0.72 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132608 AND `FinanceRatios`.`Year_end` = 200603 AND `FinanceRatios`.`Type` = \'C\'
132608 200603 C 16.48 3.30 3.80 1.00 72.99 29.47 30.75 35.09 29.12 20.54 23.65 6.91 22.59 13.05 0.34 0.85 0.79 1.18 149.79 44.11 76.09 5.54 24.06 6.26 0.22 6.85 17.93 19.52 2.55 5.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.96 9.02 8.25 5.88 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 33.82 0.90 53.12 6.07 5.27 5.27 94.73 6.26 35.09 59.84 75967.68 0.03 6.01 -6.99 -13.07 -43.74 -2.09 -0.48 -11.48 32.23 0.34 9.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.71 0.83 29.12 20.54 96.37 11.80 3.27 22.59 3.35 16.38 2.01 21.37 6.07 7.75 9.79 32.03 39.78 28.06 0.00 0.00 0.00 0.00 0.00 0.00 8.27 2.44 27.71 14.60 0.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 38.20 32.23 1.79 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132608 AND `FinanceRatios`.`Year_end` = 200903 AND `FinanceRatios`.`Type` = \'C\'
132608 200903 C 5.81 5.81 7.98 2.00 47.72 34.36 31.01 30.75 22.40 14.70 20.17 5.94 12.66 14.48 0.40 0.88 1.44 1.14 84.85 45.55 46.94 8.16 5.94 0.99 4.22 1.55 4.28 5.04 0.74 1.20 8.22 -45.16 -40.24 -46.54 -53.12 -53.12 -53.13 -53.13 0.60 2.95 2.43 3.68 0.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -8.66 -53.12 8.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 60.67 0.74 39.42 0.00 0.00 0.00 74.93 0.99 30.75 30.96 150211.80 0.05 4.28 9.64 4.92 -18.48 -2.57 -0.39 4.10 27.87 0.40 7.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.66 0.73 22.40 14.70 121.24 12.17 2.13 12.66 10.69 41.44 3.31 11.15 34.41 3.97 8.86 18.88 22.86 15.00 0.00 0.00 0.00 0.00 0.00 0.00 8.01 4.30 8.16 47.72 2.00 8.20 5.30 86.78 -45.86 -46.54 -53.71 -41.45 0.00 113.43 -71.06 36.23 27.87 0.60 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132608 AND `FinanceRatios`.`Year_end` = 200703 AND `FinanceRatios`.`Type` = \'C\'
132608 200703 C 6.90 6.90 7.61 1.00 33.89 33.20 45.18 48.18 42.03 28.08 30.94 12.50 29.70 23.34 0.45 1.06 0.67 0.94 172.57 30.84 58.29 22.48 20.40 4.58 0.64 6.98 13.67 14.48 2.67 6.31 77.59 160.94 137.31 143.86 142.73 142.73 109.34 -58.13 0.90 17.78 16.64 7.83 0.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 83.20 -58.14 -53.56 0.00 0.00 0.00 0.00 0.00 0.00 0.00 52.72 0.87 81.54 14.23 12.91 12.91 86.85 4.58 48.18 43.90 410035.77 0.08 13.67 -7.36 -21.09 -18.59 -8.34 -0.12 -3.34 44.89 0.35 3.96 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.67 0.87 42.03 28.08 99.01 17.11 2.38 29.70 4.97 6.54 2.18 19.84 14.49 4.15 14.92 35.45 39.59 26.45 0.00 0.00 0.00 0.00 0.00 0.00 11.84 2.12 22.48 33.89 1.00 169.24 69.02 82.51 147.33 143.86 156.28 132.30 0.00 78.20 96.97 51.04 44.89 0.80 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132864 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
132864 202003 C 4.14 4.14 6.27 0.00 48.30 -16.87 8.52 7.64 5.44 6.35 9.62 4.62 8.83 6.99 0.73 1.55 4.59 0.65 75.28 86.86 141.92 7.26 4.79 0.62 0.00 0.77 7.09 10.12 0.68 0.46 -33.81 -36.07 -26.49 -35.02 -5.72 -5.72 -5.72 -5.72 0.54 1.68 0.97 3.46 0.86 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.97 -5.72 6.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 65.11 1.87 42.48 0.00 0.00 0.00 100.00 0.62 7.64 28.92 43843.67 1.54 7.09 3.65 8.24 4.09 7.34 0.14 17.86 8.71 0.73 50.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.17 0.71 5.44 6.35 186.94 5.56 1.91 8.83 5.56 39.94 1.61 8.55 0.00 3.24 3.96 7.57 10.81 12.63 0.00 0.00 0.00 0.00 0.00 0.00 4.20 4.85 7.26 48.30 0.00 6.34 -0.41 1.08 -34.04 -35.02 -46.26 -2.02 25.27 -20.23 -57.91 10.91 8.71 0.34 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132864 AND `FinanceRatios`.`Year_end` = 202303 AND `FinanceRatios`.`Type` = \'C\'
132864 202303 C 3.37 3.37 6.18 0.40 53.84 26.25 6.28 5.66 3.19 2.35 4.25 2.99 6.53 9.58 1.27 2.35 9.89 0.43 71.65 45.76 104.67 26.42 14.42 1.65 0.45 0.77 10.19 13.62 1.26 0.61 36.30 36.63 41.51 59.33 109.04 109.04 120.14 120.14 0.65 1.31 0.93 2.29 0.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 20.74 109.04 6.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 60.67 2.75 32.76 0.00 0.00 0.00 93.53 1.65 5.66 29.53 97361.79 1.03 10.19 9.25 9.63 3.13 28.48 0.04 15.71 5.09 1.23 66.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.74 0.56 3.19 2.35 275.66 6.95 2.19 6.53 10.27 80.47 3.03 6.32 11.86 3.45 3.92 8.58 12.02 8.87 0.00 0.00 0.00 0.00 0.00 0.00 7.98 5.09 26.42 53.84 0.40 6.05 6.79 1.55 54.39 59.33 111.64 45.88 44.36 41.12 50.95 7.56 5.09 0.21 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132864 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'C\'
132864 202103 C 1.04 1.04 3.54 0.20 49.44 26.42 7.54 4.80 2.00 1.47 5.01 1.12 2.13 4.58 0.76 1.37 5.97 0.73 82.15 73.17 131.27 62.30 18.30 1.31 0.31 1.16 13.90 24.14 1.11 0.92 8.51 -3.87 -17.11 -31.84 -74.89 -74.89 -74.89 -74.89 0.50 1.39 0.94 1.71 0.38 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 37.74 -74.89 2.36 0.00 0.00 0.00 0.00 0.00 0.00 0.00 66.70 1.35 45.95 0.00 0.00 0.00 94.35 1.31 4.80 25.57 71288.75 1.62 13.90 9.49 6.82 -12.35 -5.24 -0.19 7.45 5.53 0.73 55.62 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.74 0.42 2.00 1.47 135.40 3.52 1.90 2.13 8.03 56.02 2.05 2.08 19.24 1.13 1.46 2.79 3.92 2.88 0.00 0.00 0.00 0.00 0.00 0.00 4.99 4.44 62.30 49.44 0.20 2.36 7.86 44.17 -31.03 -31.84 -60.11 -43.56 11.37 -48.16 115.47 8.34 5.53 0.25 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132864 AND `FinanceRatios`.`Year_end` = 202403 AND `FinanceRatios`.`Type` = \'C\'
132864 202403 C 6.24 6.24 9.03 0.40 59.68 20.70 7.28 7.91 5.42 4.29 6.20 5.04 11.02 12.37 1.17 2.32 8.97 0.43 80.21 50.11 129.29 20.58 14.22 2.15 0.31 1.07 12.78 13.58 1.60 0.88 0.23 16.26 11.55 40.15 82.98 82.98 85.02 85.02 0.63 1.30 0.90 3.17 0.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 1.30 82.98 10.84 0.00 0.00 0.00 0.00 0.00 0.00 0.00 61.22 2.84 38.72 0.00 0.00 0.00 95.57 2.15 7.91 29.07 136104.31 1.03 10.95 2.20 58.34 -0.82 -156.78 -0.01 66.16 5.92 1.12 68.43 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.79 0.68 5.42 4.29 284.13 8.85 2.19 11.02 9.60 82.32 2.79 10.45 6.41 2.75 6.06 13.26 16.01 12.70 0.00 0.00 0.00 0.00 0.00 0.00 7.28 4.55 20.58 59.68 0.40 10.84 10.03 1.72 16.52 40.15 70.19 46.15 41.23 15.77 44.17 8.41 5.92 0.19 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 132864 AND `FinanceRatios`.`Year_end` = 202203 AND `FinanceRatios`.`Type` = \'C\'
132864 202203 C 1.53 1.53 4.23 0.30 50.77 25.33 6.26 4.84 2.05 1.53 3.97 1.58 3.26 6.57 1.03 1.74 6.68 0.57 79.61 54.54 124.19 38.53 13.93 1.16 0.51 0.79 10.84 16.30 1.01 0.55 50.79 25.21 31.63 51.96 57.32 57.32 47.36 47.36 0.63 1.41 0.94 1.74 0.54 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 49.78 57.32 2.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 61.24 1.98 43.03 0.00 0.00 0.00 92.92 1.16 4.84 29.03 73135.22 0.88 10.84 -1.49 -39.72 -8.92 -6.61 -0.15 -71.75 4.49 0.96 61.57 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.75 0.42 2.05 1.53 198.63 4.66 2.07 3.26 9.24 70.44 2.68 3.19 19.59 2.13 1.98 4.09 6.22 4.64 0.00 0.00 0.00 0.00 0.00 0.00 6.69 4.58 38.52 50.77 0.30 2.69 14.68 0.39 22.44 51.96 55.03 19.68 68.11 97.56 -8.88 7.28 4.49 0.31 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 279040 AND `FinanceRatios`.`Year_end` = 201603 AND `FinanceRatios`.`Type` = \'C\'
279040 201603 C -0.12 -0.12 0.45 0.00 8.08 42.58 -0.41 0.93 0.69 0.40 0.53 0.56 4.24 5.98 1.42 756.16 10.05 0.00 151.45 0.00 0.00 0.00 36.15 2.04 0.00 0.15 12.89 16.46 0.98 0.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.66 1.18 1.18 3.90 0.32 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 60.25 828.04 41.49 0.00 0.00 0.00 100.00 2.04 0.93 8.72 50822282.00 0.29 14.43 0.00 0.00 0.34 48.02 0.02 0.00 0.94 1.42 84.43 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.57 0.74 0.69 0.40 0.00 1.31 7.57 4.24 3.86 590.45 0.34 4.24 0.00 17.05 0.98 7.38 24.43 14.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.41 0.00 8.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.18 0.94 0.66 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 279040 AND `FinanceRatios`.`Year_end` = 201703 AND `FinanceRatios`.`Type` = \'C\'
279040 201703 C 0.15 0.15 0.17 0.00 8.23 22.02 -6.73 1.64 1.64 1.28 1.44 0.32 1.89 1.13 0.25 105.67 0.65 0.01 800.11 0.00 1521.10 116.92 103.93 2.19 0.00 2.11 117.53 128.96 1.18 1.49 -86.03 -130.93 -78.74 -75.26 -54.90 -54.90 227.29 227.33 1.63 2.47 2.47 475.66 0.74 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.80 -54.90 1.88 0.00 0.00 0.00 0.00 0.00 0.00 0.00 38.01 141.88 141.48 0.00 0.00 0.00 100.00 2.19 1.64 39.11 98516489.00 2.09 117.53 -12.55 -1.44 -13.89 -1.30 -0.77 -0.96 1.80 0.35 40.38 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.78 1.00 1.64 1.28 0.00 0.58 5.85 1.89 0.00 153.82 0.00 1.88 0.00 12.55 0.58 3.38 15.93 12.42 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.46 116.90 8.23 0.00 1.88 -43.85 0.00 -73.44 -75.26 -66.79 -61.80 0.00 0.00 9.79 1.80 1.80 1.63 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 283136 AND `FinanceRatios`.`Year_end` = 202003 AND `FinanceRatios`.`Type` = \'C\'
283136 202003 C 1.03 1.03 1.50 0.00 12.60 32.26 6.73 6.13 2.68 1.82 2.64 2.70 8.96 14.40 1.49 19.23 3.39 0.05 56.66 158.70 195.38 9.95 5.93 0.71 0.00 0.40 5.55 6.52 0.90 0.18 25.41 0.01 4.63 6.09 -22.91 -22.91 -30.96 -72.39 1.00 1.72 0.51 1.78 1.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 39.59 -72.39 -57.06 0.00 0.00 0.00 0.00 0.00 0.00 0.00 50.03 39.09 65.53 0.00 0.00 0.00 100.00 0.71 6.13 29.63 187278974.00 1.19 5.75 1.29 7.96 -1.05 -9.84 -0.10 44.00 3.76 1.34 49.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.68 0.44 2.68 1.82 4094.76 8.21 3.31 8.96 15.58 187.91 4.62 8.17 0.00 2.15 3.60 11.92 14.07 9.53 0.00 0.00 0.00 0.00 0.00 0.00 2.30 6.44 8.60 12.60 0.00 19.87 24.53 4.98 -14.90 6.09 -18.88 -21.53 0.00 0.00 -43.51 7.20 3.76 0.51 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 283136 AND `FinanceRatios`.`Year_end` = 202303 AND `FinanceRatios`.`Type` = \'C\'
283136 202303 C 0.15 0.15 1.70 0.00 23.63 23.43 7.98 5.56 0.29 0.22 3.98 0.24 0.51 7.87 1.08 5.95 1.81 0.17 70.72 168.02 123.50 474.48 41.01 2.96 0.00 2.03 21.83 36.60 2.51 1.89 -22.01 34.98 27.58 21.17 -77.94 -77.94 -70.57 -70.57 0.39 3.08 1.18 1.06 0.11 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.31 -80.64 50.15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 71.88 7.58 65.33 0.00 0.00 0.00 100.00 2.96 5.56 22.15 8691.51 0.85 19.08 -1.55 -45.04 -7.15 -9.77 -0.10 -27.57 4.05 1.02 22.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.77 0.05 0.29 0.22 767.39 5.69 2.11 0.51 24.35 61.32 5.39 0.32 0.00 2.26 0.30 0.63 2.89 2.22 0.00 0.00 0.00 0.00 0.00 0.00 2.17 5.16 474.46 23.63 0.00 71.10 12.10 18.89 -1.60 21.17 -79.08 6.67 0.00 0.00 63.98 9.32 4.05 0.05 0.00 0.00 0.00 0.00 A
编辑 编辑复制 复制删除 删除
DELETE FROM `FinanceRatios` WHERE `FinanceRatios`.`fin_code` = 283136 AND `FinanceRatios`.`Year_end` = 202103 AND `FinanceRatios`.`Type` = \'C\'
283136 202103 C 1.70 1.70 2.71 0.00 15.23 26.17 9.71 8.24 4.55 3.36 5.70 4.54 12.51 17.84 1.35 13.10 3.28 0.08 53.15 173.74 236.44 14.85 8.05 1.43 0.00 0.70 6.53 8.46 1.42 0.53 1.88 47.07 50.99 36.93 88.37 -100.00 64.23 64.23 0.53 1.87 0.54 2.24 0.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8.95 54.57 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 65.45 15.19 60.00 0.00 0.00 0.00 100.00 1.43 8.24 22.56 3326.64 2.11 6.59 2.95 8.56 0.73 34.39 0.03 16.12 6.99 1.33 42.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.74 0.55 4.55 3.36 1541.73 10.99 2.76 12.51 21.79 121.29 4.92 10.45 0.00 3.01 6.08 16.76 19.76 14.59 0.00 0.00 0.00 0.00 0.00 0.00 2.10 6.87 12.84 15.23 0.00 47.33 2.29 92.14 89.50 36.93 72.84 120.05 0.00 0.00 198.74 10.68 6.99 0.14 0.00 0.00 0.00 0.00 A
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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