The attached query is in Informix format.
I would like to build on this query. I would like a extra column called 'difference' that does the following - if the user is the same as the previous record it will time-time from previous record. if not then null.
I would then like another column called gap. If the 'difference' is greater than 5 minutes then 1 else 0
14 freelancers are bidding on average £19 for this job
Hi, I would like to write the query to get the time difference and gap from previous row. Available to start now. please get in touch to discuss more. Regards, Manish