Informix SQL, Query - time difference between previous record
£10-20 GBP
Płatność przy odbiorze
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
Numer ID Projektu: #17080081
O projekcie
12 freelancerów złożyło ofertę za £19 w tym projekcie
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
Hi there, I'm Aly I've seen your post and I'm interested. I've had much experience with Microsoft SQL Server, including building dynamic and relatively complex queries. Requirements seems clear. In fact, I've already Więcej
Hello, I am interested in your project, I am a Senior .net Software Engineer with 6+ years of working experience in Software applications full life cycle. i have already done sql queries for you that add two new colum Więcej
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Więcej
I have worked on PL SQL for 5 years. Relevant Skills and Experience PL SQL, postgres, ETL, Unix, excel