If the current row has a value of 5000 and the 3 preceding rows have a value ( in order )1000,1500 and 3000 which rows would be included In ROWS BETWEEN 2 PRECEDING and 1 PRECEDING?

Hello , I have 2 tables Table A and Table B. Table A contains Customer Id,City Table B contains Customer Id,Address I need to find the list of customer IDs who belongs to Table A but in Table B. How to perform this in hana calculation view ...

Hi Team, How to delete values from hana database if some of the values are null using placeholder Delete from table where C1 = ? and C2 = ? and C3 = ? [ 1,null,null]

Hi all, Abc_123_adf Cvg_456_jku_akl Lop_789_asw Need output: 123 456 789 How to achieve this using expression in hana calculation view

Hello all, I have 2 tables a and b where Table a contains duplicate records of multiple occurrences. How to select one occurence of duplicate records from one hana table and insert into another table Regards, Nagendra