I want to Execute SQL query on my Index data , where i have 6 records of same transaction id in Index.
In each record there is timestamp , so i need to calculate timestamp diff between 1st , 6th and 2dn ,3rd and then need calculate difference of there two difference .
The query is using Groupby By - transaction id , but i am not able to run it without non -grouped element.
Please Help !!