برندینگ و برندسازی: oracle - Select with multiple registry

۱۳۹۶ تیر ۱۳, سه‌شنبه

oracle - Select with multiple registry

[ad_1]

This is my database

NUM_DOC_CLT COD_UPB FEC_VGN

17465367-8 001 30-06-2017
17465367-8 002 16-06-2017
17465367-8 002 30-06-2017
17465367-8 001 25-06-2017

I need to select the type of code with the most recent date.

17465367-8 001 30-06-2017
17465367-8 002 30-06-2017

This is my query that works but only when the user has a type of code

SELECT 
 TRIM(CODIGO_PARAMETRO) CODIGO_PARAMETRO,
 NH.FEC_VGN 
 FROM 
 NHNS_DT_INTFZ_UPBC NH, 
 GRALPARAMCH GR
 WHERE 
 NH.NUM_DOC_CLT = P_RUT
 AND NH.COD_UPB = SUBSTR(VALOR_PARAMETRO,0,3)
 AND NH.FEC_VGN = (SELECT MAX(FEC_VGN) FROM NHNS_DT_INTFZ_UPBC WHERE NUM_DOC_CLT = P_RUT)
 AND GR.CODIGO_PARAMETRO IN ('UPBC_PEP','UPBC_FALLE','UPBC_UAF');

[ad_2]

لینک منبع

دنبال کننده ها

۱۳۹۶ تیر ۱۳, سه‌شنبه

oracle - Select with multiple registry