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
I suppose you're using Informix 12.1 of higher version. I think something like this would be useful: SELECT idc_userid as User, event_ts as time, after_event_qty as Qty, event_loc1_text as Location, to_c Daha Fazla
Bu iş için 14 freelancer ortalamada £19 teklif veriyor
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
Dear Hiring Manager, I read your job description and I am confident that I can exceed your expectations. I am a professional programmer on Database Administration, Microsoft SQL Server, MySQL, Oracle, [login to view URL] per y Daha Fazla
Hi, there i read your initial requirements and i have some question regarding to your sql query [login to view URL] can we discuss it on chat ?
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 Daha Fazla
Hi i could able to finish this please let me know do we take exactly previous record
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 Daha Fazla
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 Daha Fazla
I have worked on PL SQL for 5 years. Relevant Skills and Experience PL SQL, postgres, ETL, Unix, excel