将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenDionNewsData »表: FinanceConsolidatedBankingVI
页面相关设置 点击以滚动到页面顶部
按 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 字段的文本框放大一倍。
字段类型函数
CompanyCodedouble(20,2)
YearEndingvarchar(40)
Monthsint(10)
Typevarchar(10)
FaceValuedouble(20,2)
InterestDiscountOnAdvancesBillsdouble(20,2)
IncomeFromInvestmentsdouble(20,2)
InterestOnBalanceWithRBIAndOtherInterBankFundsdouble(20,2)
Othersdouble(20,2)
TotalInterestEarneddouble(20,2)
OtherIncomedouble(20,2)
TotalIncomedouble(20,2)
InterestExpendeddouble(20,2)
PaymentsToAndProvisionsForEmployeesdouble(20,2)
Depreciationdouble(20,2)
DepreciationOnLeasedAssetsdouble(20,2)
OperatingExpensesExcludesEmployeeCostAndDepreciationdouble(20,2)
TotalOperatingExpensesdouble(20,2)
ProvisionTowardsIncomeTaxdouble(20,2)
ProvisionTowardsDeferredTaxdouble(20,2)
ProvisionTowardsOtherTaxesdouble(20,2)
OtherProvisionsAndContingenciesdouble(20,2)
TotalProvisionsAndContingenciesdouble(20,2)
TotalExpendituredouble(20,2)
NetProfitLossForTheYeardouble(20,2)
PriorPeriodItemsdouble(20,2)
ExtraordinaryItemsdouble(20,2)
NetProfitLossForTheYearAfterEIdouble(20,2)
IncomeMinorityInterestdouble(20,2)
ShareOfProfitLossFromAssociatedouble(20,2)
ProfitLossAfterMIAndAssociatesdouble(20,2)
ProfitLossBroughtForwarddouble(20,2)
TransferredOnAmalgamationdouble(20,2)
TotalProfitLossdouble(20,2)
TransferToFromStatutoryReservedouble(20,2)
TransferToFromReserveFunddouble(20,2)
TransferToFromSpecialReservedouble(20,2)
TransferToFromCapitalReservedouble(20,2)
TransferToFromGeneralReservedouble(20,2)
TransferToFromInvestmentReservedouble(20,2)
TransferToFromRevenueAndOtherReservesdouble(20,2)
DividendForThePreviousYeardouble(20,2)
EquityShareDividenddouble(20,2)
PreferenceShareDividenddouble(20,2)
TaxOnDividenddouble(20,2)
BalanceCarriedOverToBalanceSheetdouble(20,2)
TotalAppropriationsdouble(20,2)
EquitySharesdouble(20,2)
EquityCapitaldouble(20,2)
PreferenceCapitaldouble(20,2)
TotalShareCapitaldouble(20,2)
RevaluationReservesdouble(20,2)
ReservesAndSurplusdouble(20,2)
TotalReservesAndSurplusdouble(20,2)
MoneyAgainstShareWarrantsdouble(20,2)
EmployeesStockOptionsdouble(20,2)
TotalShareHoldersFundsdouble(20,2)
EquityShareApplicationMoneydouble(20,2)
PrefShareApplicationMoneydouble(20,2)
ShareCapitalSuspensedouble(20,2)
LiabilityMinorityInterestdouble(20,2)
PolicyHoldersFundsdouble(20,2)
LiabilityGroupShareInJointVenturesdouble(20,2)
Depositsdouble(20,2)
Borrowingsdouble(20,2)
OtherLiabilitiesAndProvisionsdouble(20,2)
TotalCapitalAndLiabilitiesdouble(20,2)
CashAndBalancesWithReserveBankOfIndiadouble(20,2)
BalancesWithBanksMoneyAtCallAndShortNoticedouble(20,2)
Investmentsdouble(20,2)
Advancesdouble(20,2)
FixedAssetsdouble(20,2)
OtherAssetsdouble(20,2)
AssetMinorityInterestdouble(20,2)
AssetGroupShareInJointVenturesdouble(20,2)
TotalAssetsdouble(20,2)
NetProfitLossBeforeExtraordinaryItemsAndTaxdouble(20,2)
NetCashFlowFromOperatingActivitiesdouble(20,2)
NetCashUsedInInvestingActivitiesdouble(20,2)
NetCashUsedFromFinancingActivitiesdouble(20,2)
ForeignExchangeGainsLossesdouble(20,2)
NetIncDecInCashAndCashEquivalentsdouble(20,2)
CashAndCashEquivalentBeginOfYeardouble(20,2)
CashAndCashEquivalentEndOfYeardouble(20,2)
BasicEPSdouble(20,2)
DilutedEPSdouble(20,2)
NumberOfBranchesdouble(20,2)
NumberOfEmployeesdouble(20,2)
CapitalAdequacyRatiosdouble(20,2)
KeyPerformanceTier1double(20,2)
KeyPerformanceTier2double(20,2)
GrossNPARsdouble(20,2)
GrossNPAPercentagedouble(20,2)
NetNPARsdouble(20,2)
NetNPAPercentagedouble(20,2)
NetNPAToAdvancesPercentagedouble(20,2)
BillsForCollectiondouble(20,2)
ContingentLiabilitiesdouble(20,2)
BonusEquityShareCapitaldouble(20,2)
ModifiedDatevarchar(40)


字段类型函数
CompanyCodedouble(20,2)
YearEndingvarchar(40)
Monthsint(10)
Typevarchar(10)
FaceValuedouble(20,2)
InterestDiscountOnAdvancesBillsdouble(20,2)
IncomeFromInvestmentsdouble(20,2)
InterestOnBalanceWithRBIAndOtherInterBankFundsdouble(20,2)
Othersdouble(20,2)
TotalInterestEarneddouble(20,2)
OtherIncomedouble(20,2)
TotalIncomedouble(20,2)
InterestExpendeddouble(20,2)
PaymentsToAndProvisionsForEmployeesdouble(20,2)
Depreciationdouble(20,2)
DepreciationOnLeasedAssetsdouble(20,2)
OperatingExpensesExcludesEmployeeCostAndDepreciationdouble(20,2)
TotalOperatingExpensesdouble(20,2)
ProvisionTowardsIncomeTaxdouble(20,2)
ProvisionTowardsDeferredTaxdouble(20,2)
ProvisionTowardsOtherTaxesdouble(20,2)
OtherProvisionsAndContingenciesdouble(20,2)
TotalProvisionsAndContingenciesdouble(20,2)
TotalExpendituredouble(20,2)
NetProfitLossForTheYeardouble(20,2)
PriorPeriodItemsdouble(20,2)
ExtraordinaryItemsdouble(20,2)
NetProfitLossForTheYearAfterEIdouble(20,2)
IncomeMinorityInterestdouble(20,2)
ShareOfProfitLossFromAssociatedouble(20,2)
ProfitLossAfterMIAndAssociatesdouble(20,2)
ProfitLossBroughtForwarddouble(20,2)
TransferredOnAmalgamationdouble(20,2)
TotalProfitLossdouble(20,2)
TransferToFromStatutoryReservedouble(20,2)
TransferToFromReserveFunddouble(20,2)
TransferToFromSpecialReservedouble(20,2)
TransferToFromCapitalReservedouble(20,2)
TransferToFromGeneralReservedouble(20,2)
TransferToFromInvestmentReservedouble(20,2)
TransferToFromRevenueAndOtherReservesdouble(20,2)
DividendForThePreviousYeardouble(20,2)
EquityShareDividenddouble(20,2)
PreferenceShareDividenddouble(20,2)
TaxOnDividenddouble(20,2)
BalanceCarriedOverToBalanceSheetdouble(20,2)
TotalAppropriationsdouble(20,2)
EquitySharesdouble(20,2)
EquityCapitaldouble(20,2)
PreferenceCapitaldouble(20,2)
TotalShareCapitaldouble(20,2)
RevaluationReservesdouble(20,2)
ReservesAndSurplusdouble(20,2)
TotalReservesAndSurplusdouble(20,2)
MoneyAgainstShareWarrantsdouble(20,2)
EmployeesStockOptionsdouble(20,2)
TotalShareHoldersFundsdouble(20,2)
EquityShareApplicationMoneydouble(20,2)
PrefShareApplicationMoneydouble(20,2)
ShareCapitalSuspensedouble(20,2)
LiabilityMinorityInterestdouble(20,2)
PolicyHoldersFundsdouble(20,2)
LiabilityGroupShareInJointVenturesdouble(20,2)
Depositsdouble(20,2)
Borrowingsdouble(20,2)
OtherLiabilitiesAndProvisionsdouble(20,2)
TotalCapitalAndLiabilitiesdouble(20,2)
CashAndBalancesWithReserveBankOfIndiadouble(20,2)
BalancesWithBanksMoneyAtCallAndShortNoticedouble(20,2)
Investmentsdouble(20,2)
Advancesdouble(20,2)
FixedAssetsdouble(20,2)
OtherAssetsdouble(20,2)
AssetMinorityInterestdouble(20,2)
AssetGroupShareInJointVenturesdouble(20,2)
TotalAssetsdouble(20,2)
NetProfitLossBeforeExtraordinaryItemsAndTaxdouble(20,2)
NetCashFlowFromOperatingActivitiesdouble(20,2)
NetCashUsedInInvestingActivitiesdouble(20,2)
NetCashUsedFromFinancingActivitiesdouble(20,2)
ForeignExchangeGainsLossesdouble(20,2)
NetIncDecInCashAndCashEquivalentsdouble(20,2)
CashAndCashEquivalentBeginOfYeardouble(20,2)
CashAndCashEquivalentEndOfYeardouble(20,2)
BasicEPSdouble(20,2)
DilutedEPSdouble(20,2)
NumberOfBranchesdouble(20,2)
NumberOfEmployeesdouble(20,2)
CapitalAdequacyRatiosdouble(20,2)
KeyPerformanceTier1double(20,2)
KeyPerformanceTier2double(20,2)
GrossNPARsdouble(20,2)
GrossNPAPercentagedouble(20,2)
NetNPARsdouble(20,2)
NetNPAPercentagedouble(20,2)
NetNPAToAdvancesPercentagedouble(20,2)
BillsForCollectiondouble(20,2)
ContingentLiabilitiesdouble(20,2)
BonusEquityShareCapitaldouble(20,2)
ModifiedDatevarchar(40)

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

继续插入