hi,
sample
id,reqtime,resptime,batch
1,18/9/2018 2:30, 18/9/2018 2:31,batch-44
2,18/9/2018 2:32, 18/9/2018 2:33,batch-44
result:
18/9/2018 2:33 - 18/9/2018 2:30 = 180sec
i want prepare query for this is there any way we can do the difference between the max(date)-min(date)
from required total documents.