将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

编辑模式

自定义编辑模式。

文档 禁止编辑 BLOB 和 BINARY 类型字段。
文档 在编辑/插入模式中显示函数列.
文档 定义在编辑/插入模式中是否默认显示字段类型一列。
文档 一次可以插入的行数。
文档 外键下拉框中选项的排序顺序，content 为关联内容，id 为键值。
文档 下拉框将在选项少时使用。
文本字段

自定义文本输入框。

文档 当编辑 CHAR 和 VARCHAR 类型字段时所使用的控件；输入框（input） - 可以限制输入长度，文本框（textarea） - 可以输入多行数据。
文档 定义了当编辑 CHAR 和 VARCHAR 字段时所使用输入框的最小大小。
文档 定义了当编辑 CHAR 和 VARCHAR 字段时所使用输入框的最大大小。
文档 CHAR/VARCHAR 文本框的列数。
文档 CHAR/VARCHAR 文本框的行数。
文档 编辑模式的文本区大小 (列数)，此值将用于 SQL 查询文本区 (*2)。
文档 编辑模式的文本区大小 (行数)，此值将用于 SQL 查询文本区 (*2) 。
文档 将 LONGTEXT 字段的文本框放大一倍。
字段类型函数空值
fin_codeint(15)
Result_Typevarchar(2)
No_monthsint(15)
Typevarchar(1)
Date_Endint(15)
Net_Salesdouble(20,2)
Gross_Saledouble(20,2)
Excise_Dutydouble(20,2)
Other_NetSalesdouble(20,2)
Job_Worksdouble(20,2)
Other_Incomedouble(20,2)
Dividend_Incomedouble(20,2)
Export_Incentivesdouble(20,2)
Foreign_exchange_gaindouble(20,2)
Profit_Investmentdouble(20,2)
Other_Interest_incomedouble(20,2)
rental_incomedouble(20,2)
Sale_Shares_Unitsdouble(20,2)
Prov_written_backdouble(20,2)
Sale_Assetsdouble(20,2)
Other_Other_Incomedouble(20,2)
Total_Incomedouble(20,2)
Expendituredouble(20,2)
Inc_Dec_Inventorydouble(20,2)
Excisedouble(20,2)
Raw_Material_Costdouble(20,2)
PURCHASE_FIN_GOODdouble(20,2)
Mfg_Expsdouble(20,2)
Electricity_Power_Fueldouble(20,2)
Exployee_Costdouble(20,2)
Interestdouble(20,2)
Depreciationdouble(20,2)
Gen_AdminExpensesdouble(20,2)
Selling_Dist_Expensesdouble(20,2)
Misc_Expensesdouble(20,2)
Loss_Foreign_exchangedouble(20,2)
LossForeignExchangeLoandouble(20,2)
Expence_Capitaliseddouble(20,2)
PB_ExItem_SATaxdouble(20,2)
Exception_Itemsdouble(20,2)
Exc_foreign_exch_gaindouble(20,2)
Exc_otherdouble(20,2)
PB_SATaxdouble(20,2)
Shares_Associatedouble(20,2)
Pbtdouble(20,2)
Taxdouble(20,2)
Curr_taxdouble(20,2)
Def_taxdouble(20,2)
Fringe_benefitsdouble(20,2)
Prior_Period_Taxdouble(20,2)
Mat_Creditdouble(20,2)
Other_Taxdouble(20,2)
Patdouble(20,2)
Pbt_DiscOperationsdouble(20,2)
TaxExp_DiscOperationsdouble(20,2)
Discontinued_Opdouble(20,2)
Other_related_itemsdouble(20,2)
Net_Profitdouble(20,2)
Other_CompIncomedouble(20,2)
Items_NotClassif_PLdouble(20,2)
IT_Items_NotClassif_PLdouble(20,2)
Items_Classif_PLdouble(20,2)
IT_Items_Classif_PLdouble(20,2)
MININT_COMPINCOMEdouble(20,2)
OthCinc_Otherdouble(20,2)
TOTAL_COMPINCOMEdouble(20,2)
NetProfit_OwnOfParentdouble(20,2)
NetProfit_NonContIntdouble(20,2)
Other_CompInc_OwnOfParentdouble(20,2)
Other_CompInc_NonContIntdouble(20,2)
TotalCompIncome_OwnOfParentdouble(20,2)
Minority_interestdouble(20,2)
Equity_Capdouble(20,2)
Fvdouble(20,2)
Reservesdouble(20,2)
EPSAbsdouble(20,2)
EPSAnndouble(20,2)
Adj_eps_absdouble(20,2)
Adj_eps_anndouble(20,2)
eps_basicdouble(20,2)
eps_diluted_extraorddouble(20,2)
PBIDTMEXOIdouble(20,2)
PBIDTMdouble(20,2)
PBDTMdouble(20,2)
PBTMdouble(20,2)
PATMdouble(20,2)
Rev_Div_Incomedouble(20,2)
Rev_Fee_Commdouble(20,2)
Rev_Gain_Fairvaluedouble(20,2)
Rev_Gain_finassetsdouble(20,2)
Inc_Invdouble(20,2)
Int_Baldouble(20,2)
Int_Advdouble(20,2)
Int_Othersdouble(20,2)
Operating_Exdouble(20,2)
Prov_Empdouble(20,2)
Other_Expdouble(20,2)
Operating_Profitdouble(20,2)
Pacdouble(20,2)
EIdouble(20,2)
PPIdouble(20,2)
Govt_Percent_Of_Sharesdouble(20,2)
Cap_Ratio_Percentdouble(20,2)
Cap_Ratio_Percent3double(20,2)
Tier1basel3double(20,2)
Tier2basel3double(20,2)
Gross_Net_Npadouble(20,2)
NPA_Grossdouble(20,2)
NPA_Netdouble(20,2)
Perc_Gross_Net_Npadouble(20,2)
NPA_Net_percdouble(20,2)
NPA_Gross_percdouble(20,2)
Roadouble(20,2)
Prom_No_Of_Sharesdouble(20,2)
Prom_Percent_Of_Sharesdouble(20,2)
eps_basic_extraorddouble(20,2)
eps_diluteddouble(20,2)
Promoter_NOSdouble(20,2)
Encumbered_NOSdouble(20,2)
percentage_pledgedpromoterdouble(20,2)
Percentage_PledgedCapitaldouble(20,2)
NonPledgedEncumdouble(20,2)
NonPledged_NOSdouble(20,2)
Percentage_NonPledgedPromoterdouble(20,2)
Percentage_NonPledgedCapitaldouble(20,2)
CASAdouble(20,2)
CASA_AMOUNTdouble(20,2)
NIMdouble(20,2)
GROSS_PROFITdouble(20,2)
PREF_CAPdouble(20,2)
Misc_expd_woffdouble(20,2)
Consolidated_net_profitdouble(20,2)
NOTESmediumtext
Return on Capital Employeddouble(20,2)
Debt/Equity Ratiodouble(20,2)
Interest Coverage Ratiodouble(20,2)
Inventory Turnover Ratiodouble(20,2)
Debtor Turnover Ratiodouble(20,2)
Dividend per sharedouble(20,2)
Dividend payout ratiodouble(20,2)
Other_Adjustmentsdouble(20,2)
pbidtxoidouble(20,2)
OPERATING_PROFIT_MARGINdouble(20,2)
NET_PROFIT_MARGINdouble(20,2)
Cash_bankdouble(20,2)
Debtorsdouble(20,2)
Inventorydouble(20,2)
Loans_advdouble(20,2)
nsGrandTotaldouble(20,2)
nsTotalpublicdouble(20,2)
tpTotalpublicdouble(20,2)
Provisions_Coveragedouble(20,2)
No_of_ATMsdouble(20,2)
No_of_Branchesdouble(20,2)
Tier_I_Basel_IIdouble(20,2)
Tier_2_Basel_IIdouble(20,2)
No_of_Employesdouble(20,2)
FLAGvarchar(1)


字段类型函数空值
fin_codeint(15)
Result_Typevarchar(2)
No_monthsint(15)
Typevarchar(1)
Date_Endint(15)
Net_Salesdouble(20,2)
Gross_Saledouble(20,2)
Excise_Dutydouble(20,2)
Other_NetSalesdouble(20,2)
Job_Worksdouble(20,2)
Other_Incomedouble(20,2)
Dividend_Incomedouble(20,2)
Export_Incentivesdouble(20,2)
Foreign_exchange_gaindouble(20,2)
Profit_Investmentdouble(20,2)
Other_Interest_incomedouble(20,2)
rental_incomedouble(20,2)
Sale_Shares_Unitsdouble(20,2)
Prov_written_backdouble(20,2)
Sale_Assetsdouble(20,2)
Other_Other_Incomedouble(20,2)
Total_Incomedouble(20,2)
Expendituredouble(20,2)
Inc_Dec_Inventorydouble(20,2)
Excisedouble(20,2)
Raw_Material_Costdouble(20,2)
PURCHASE_FIN_GOODdouble(20,2)
Mfg_Expsdouble(20,2)
Electricity_Power_Fueldouble(20,2)
Exployee_Costdouble(20,2)
Interestdouble(20,2)
Depreciationdouble(20,2)
Gen_AdminExpensesdouble(20,2)
Selling_Dist_Expensesdouble(20,2)
Misc_Expensesdouble(20,2)
Loss_Foreign_exchangedouble(20,2)
LossForeignExchangeLoandouble(20,2)
Expence_Capitaliseddouble(20,2)
PB_ExItem_SATaxdouble(20,2)
Exception_Itemsdouble(20,2)
Exc_foreign_exch_gaindouble(20,2)
Exc_otherdouble(20,2)
PB_SATaxdouble(20,2)
Shares_Associatedouble(20,2)
Pbtdouble(20,2)
Taxdouble(20,2)
Curr_taxdouble(20,2)
Def_taxdouble(20,2)
Fringe_benefitsdouble(20,2)
Prior_Period_Taxdouble(20,2)
Mat_Creditdouble(20,2)
Other_Taxdouble(20,2)
Patdouble(20,2)
Pbt_DiscOperationsdouble(20,2)
TaxExp_DiscOperationsdouble(20,2)
Discontinued_Opdouble(20,2)
Other_related_itemsdouble(20,2)
Net_Profitdouble(20,2)
Other_CompIncomedouble(20,2)
Items_NotClassif_PLdouble(20,2)
IT_Items_NotClassif_PLdouble(20,2)
Items_Classif_PLdouble(20,2)
IT_Items_Classif_PLdouble(20,2)
MININT_COMPINCOMEdouble(20,2)
OthCinc_Otherdouble(20,2)
TOTAL_COMPINCOMEdouble(20,2)
NetProfit_OwnOfParentdouble(20,2)
NetProfit_NonContIntdouble(20,2)
Other_CompInc_OwnOfParentdouble(20,2)
Other_CompInc_NonContIntdouble(20,2)
TotalCompIncome_OwnOfParentdouble(20,2)
Minority_interestdouble(20,2)
Equity_Capdouble(20,2)
Fvdouble(20,2)
Reservesdouble(20,2)
EPSAbsdouble(20,2)
EPSAnndouble(20,2)
Adj_eps_absdouble(20,2)
Adj_eps_anndouble(20,2)
eps_basicdouble(20,2)
eps_diluted_extraorddouble(20,2)
PBIDTMEXOIdouble(20,2)
PBIDTMdouble(20,2)
PBDTMdouble(20,2)
PBTMdouble(20,2)
PATMdouble(20,2)
Rev_Div_Incomedouble(20,2)
Rev_Fee_Commdouble(20,2)
Rev_Gain_Fairvaluedouble(20,2)
Rev_Gain_finassetsdouble(20,2)
Inc_Invdouble(20,2)
Int_Baldouble(20,2)
Int_Advdouble(20,2)
Int_Othersdouble(20,2)
Operating_Exdouble(20,2)
Prov_Empdouble(20,2)
Other_Expdouble(20,2)
Operating_Profitdouble(20,2)
Pacdouble(20,2)
EIdouble(20,2)
PPIdouble(20,2)
Govt_Percent_Of_Sharesdouble(20,2)
Cap_Ratio_Percentdouble(20,2)
Cap_Ratio_Percent3double(20,2)
Tier1basel3double(20,2)
Tier2basel3double(20,2)
Gross_Net_Npadouble(20,2)
NPA_Grossdouble(20,2)
NPA_Netdouble(20,2)
Perc_Gross_Net_Npadouble(20,2)
NPA_Net_percdouble(20,2)
NPA_Gross_percdouble(20,2)
Roadouble(20,2)
Prom_No_Of_Sharesdouble(20,2)
Prom_Percent_Of_Sharesdouble(20,2)
eps_basic_extraorddouble(20,2)
eps_diluteddouble(20,2)
Promoter_NOSdouble(20,2)
Encumbered_NOSdouble(20,2)
percentage_pledgedpromoterdouble(20,2)
Percentage_PledgedCapitaldouble(20,2)
NonPledgedEncumdouble(20,2)
NonPledged_NOSdouble(20,2)
Percentage_NonPledgedPromoterdouble(20,2)
Percentage_NonPledgedCapitaldouble(20,2)
CASAdouble(20,2)
CASA_AMOUNTdouble(20,2)
NIMdouble(20,2)
GROSS_PROFITdouble(20,2)
PREF_CAPdouble(20,2)
Misc_expd_woffdouble(20,2)
Consolidated_net_profitdouble(20,2)
NOTESmediumtext
Return on Capital Employeddouble(20,2)
Debt/Equity Ratiodouble(20,2)
Interest Coverage Ratiodouble(20,2)
Inventory Turnover Ratiodouble(20,2)
Debtor Turnover Ratiodouble(20,2)
Dividend per sharedouble(20,2)
Dividend payout ratiodouble(20,2)
Other_Adjustmentsdouble(20,2)
pbidtxoidouble(20,2)
OPERATING_PROFIT_MARGINdouble(20,2)
NET_PROFIT_MARGINdouble(20,2)
Cash_bankdouble(20,2)
Debtorsdouble(20,2)
Inventorydouble(20,2)
Loans_advdouble(20,2)
nsGrandTotaldouble(20,2)
nsTotalpublicdouble(20,2)
tpTotalpublicdouble(20,2)
Provisions_Coveragedouble(20,2)
No_of_ATMsdouble(20,2)
No_of_Branchesdouble(20,2)
Tier_I_Basel_IIdouble(20,2)
Tier_2_Basel_IIdouble(20,2)
No_of_Employesdouble(20,2)
FLAGvarchar(1)

   然后   
按 TAB 键跳到下一个数值，或 CTRL+方向键 作随意移动.

继续插入 行