931. 下降路径最小和_DP

int minFallingPathSum2(vector<vector<int>>& A) {
    int row = A.size();
    if(row == 0) return 0;
    if(row == 1) return A[0][0];
    int col = A[0].size();

    vector<vector<int>> dp(row+1,vector<int> (col+1,INT32_MAX));
    for(int i=0;i<row;i++){
        for(int j=0;j<col;j++){
            if(i==0) dp[i][j] = A[i][j];
            else{
                if(j==0) dp[i][j] = min(dp[i-1][j],dp[i-1][j+1])+A[i][j];
                else if(j==col-1) dp[i][j] = min(dp[i-1][j-1],dp[i-1][j])+A[i][j];
                else dp[i][j] = min(dp[i-1][j-1],min(dp[i-1][j+1],dp[i-1][j]))+A[i][j];
            }
        }
    }
    return *min_element(dp[row-1].begin(),dp[row-1].end());
}
int minFallingPathSum3(vector<vector<int>>& A) {
    int row = A.size();
    if(row == 0) return 0;
    if(row == 1) return A[0][0];
    int col = A[0].size();

    vector<int> dp(col+1,INT32_MAX);
    vector<int> dp2(col+1,INT32_MAX);

    for(int i=row-1;i>=0;i--){
        for(int j=0;j<col;j++){
            if(i==row-1) dp[j] = A[i][j];
            else{
                if(j==0){
                    dp[j] = min(dp2[j],dp2[j+1]) + A[i][j];
                }else if(j==col-1){
                    dp[j] = min(dp2[j],dp2[j-1]) + A[i][j];
                }else{
                    dp[j] = min(dp2[j-1],min(dp2[j+1],dp2[j]))+A[i][j];
                }
            }
        }
        if(i!=0) swap(dp,dp2);
    }
    return *min_element(dp.begin(),dp.end());
}


class Solution {
public:
    int minFallingPathSum(vector<vector<int>>& A) {
	    int row = A.size();
	    if(row == 0) return 0;
	    if(row == 1) return A[0][0];
	    int col = A[0].size();
	
	    vector<int> dp(col+2,INT32_MAX);
	    vector<int> dp2(col+2,INT32_MAX);
	
	    for(int i=1;i<row+1;i++){
	        for(int j=1;j<col+1;j++){
	            if(i==1) dp[j] = A[i-1][j-1];
	            else{
	                dp[j] = min(dp2[j-1],min(dp2[j+1],dp2[j]))+A[i-1][j-1];
	            }
	        }
	        if(i!=row) swap(dp,dp2);
	    }
	    return *min_element(dp.begin(),dp.end());
	}
};
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
select * from ( SELECT P.PATIENT_ID, P.VISIT_ID, PM.NAME, PM.SEX, P.ADMISSION_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_ADMISSION_TO ) AS DEPT_ADM, P.DISCHARGE_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_DISCHARGE_FROM ) AS DEPT_DIS, DATEDIFF( DAY, P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) AS INPAT_DAYS, P.DOCTOR_IN_CHARGE --datediff(day, P.ADMISSION_DATE_TIME,P.DISCHARGE_DATE_TIME) as zyts FROM PAT_VISIT P INNER JOIN PAT_MASTER_INDEX PM ON PM.PATIENT_ID = P.PATIENT_ID WHERE select * from ( SELECT P.PATIENT_ID, P.VISIT_ID, PM.NAME, PM.SEX, P.ADMISSION_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_ADMISSION_TO ) AS DEPT_ADM, P.DISCHARGE_DATE_TIME, ( SELECT TOP 1 DP.DEPT_NAME FROM DEPT_DICT DP WHERE DP.DEPT_CODE = P.DEPT_DISCHARGE_FROM ) AS DEPT_DIS, DATEDIFF( DAY, P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) AS INPAT_DAYS, P.DOCTOR_IN_CHARGE --datediff(day, P.ADMISSION_DATE_TIME,P.DISCHARGE_DATE_TIME) as zyts FROM PAT_VISIT P INNER JOIN PAT_MASTER_INDEX PM ON PM.PATIENT_ID = P.PATIENT_ID WHERE P.DISCHARGE_DATE_TIME >= '2016-01-01' AND P.DISCHARGE_DATE_TIME < = '2023-07-10' AND DATEDIFF( DAY,P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) >= 30 ) t order by inpat_days desc P.DISCHARGE_DATE_TIME >= '2016-01-01' AND P.DISCHARGE_DATE_TIME < = '2023-07-10' AND DATEDIFF( DAY,P.ADMISSION_DATE_TIME, P.DISCHARGE_DATE_TIME ) >= 30 ) t order by inpat_days desc 帮我把这段sql优化一下
最新发布
07-25

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值