我有一张列如下的表格:对于每一行,我希望在下一个月的行范围内找到最大金额。account validity_date validity_month amount **required_column**当我尝试这段代码时,我在下一行中得到了值,但这不是我所需要的(每个月可以有多行):
MAX(amount) OVER (PARTITION BY a
setValidity(Validityvalidity) // ********* BREAKPOINT IS SET ON THE NEXT LINE ***********validity.LastVerified = DateTime.Now;
TimeSpan tsCheck = validity</
validate :overlapping_validity,:if => :validity_start_date_present?validity_start_date.present? and validity_end_date.present?end
errors.add(:validity_start_date,"must be earlier then validity endda