I am working on the SQL code for SAP HANA and we have the following sample code for a Table:
SELECT "MEASURINGDOC", "CHARECTERISTICNAME", "UNITOFMEASURE", "READ_DATE", "MEASURING_READ", "MESURING_POINT", "CREATEDON" FROM "_SYS_BIC"."ZPSE.SDASAPRAW/CV_BW_SAP_ZPM_O61_MEASURING_DOCUMENTS"
For each MESURING_POINT, there are several MEASURINGDOC records created over a period of time. Some have a frequency in Weeks, some are Monthly, some are Quarterly etc. Each MEASURINGDOC has the CREATEDON date.
I want to extract the 10 most recent records for each selected MESURING_POINT.
There are over 17 million records in the Table for MESURING_POINT in thousands.
I will appreciated any help from the forum.