I have a table that has 3 columns:
Column 1: contains XML data (that contains a timestamp value)
Column 2: contains the file name(with the path to it) corresponding to XML data record (as to which file that XML data is stored in)
Column 3: contains the offset of the XML data within that file
For instance, different file names can be
That is, the names assigned to the files are in incremental order.
Further each file name has different offset values in it, corresponding to the XML data value, returned above.
C:\Extended Events\ReadWrite_0_130863592475800000 can have offset values 24576, 34816, 62976 (in an increasing order too)
C:\Extended Events\ReadWrite_0_130864300903760000 can have offset values for itself independent of the above offset values.
I want to retrieve the file name and offset value corresponding to the last record returned i.e. if a total of 9 rows have been returned, I need the file name and offset value corresponding only to the 9th row. I also want it to be optimal.
MAX function isn't helping my case. I tried
max(file_name) and it simply opened the Documents folder.