Thank you for your reply. I understand that I should convert my query deleting rn=1 and then get the minimum rn group by eof, t_date I am trying...
eof_code = 228120101 is common at two tables t_date='30/01/2019' >= '28/01/2019' = s_date true t_date='30/01/2019' >= '29/01/2019' = s_date...
If there are not matched I want the maximum date where t_date >= s_date is true
Hi , I want to update the s_date and val_1 of table TABLE1 based on TABLE2. The join condition is the same eof and maximum row with ( t_date >=...
Hi all, I am trying the following query but the result is not the appropriate : With table1 as ( select '201801' as month, 1 as col1, 'A1' as...
Hi all, I am trying to create a batch script which connects to all database instances as SYS and execute a query in order to check if there are...
The string passed to the function should no contain all the values of a row of TABLE_A.COL_C. There are three invalid combinations of values , if...
Hi, I have a problem to make a function passing a string parameter with values seperated with '#' and checks if there is an invalid combination...