Informix SQL, Query - time difference between previous record

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

Skills: Database Administration, Microsoft SQL Server, MySQL, Oracle, SQL

See more: db2 sql previous row, get previous record of condition in sql server, sql add previous row value, postgres previous row, mysql select previous row value, sql select row above, sql update with previous row, multiply by previous row sql, sql query for fetch mails from the contact 7 , vb6 sql previous record, previous record record sql, improve sql query time oscommerce, reduce mysql query time cgiperl, sql delete time table, sql part time hate room php mysql, sql bulgarian time conversion, improve table structuremysql query query time alot lower, informix sql server reporting services, sql server 2005 previous record, sql migrate oracle difference

About the Employer:
( 4 reviews ) Le193ej, United Kingdom

Project ID: #17080081

Awarded to:


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 More

£10 GBP in 1 day
(3 Reviews)

14 freelancers are bidding on average £19 for this job

£28 GBP in 1 day
(28 Reviews)

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

£20 GBP in 1 day
(66 Reviews)

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 More

£18 GBP in 1 day
(8 Reviews)

I will complete youe requirement on time.

£20 GBP in 1 day
(29 Reviews)

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 ?

£18 GBP in 1 day
(13 Reviews)

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 More

£25 GBP in 0 days
(4 Reviews)

Hi i could able to finish this please let me know do we take exactly previous record

£21 GBP in 3 days
(5 Reviews)

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 More

£20 GBP in 1 day
(1 Review)
£13 GBP in 1 day
(0 Reviews)

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 More

£18 GBP in 1 day
(0 Reviews)

I have worked on PL SQL for 5 years. Relevant Skills and Experience PL SQL, postgres, ETL, Unix, excel

£13 GBP in 1 day
(0 Reviews)
£18 GBP in 1 day
(0 Reviews)
£18 GBP in 1 day
(0 Reviews)