Informix SQL, Query - time difference between previous record

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 built your query and it's ready for delivery; below is an example of the results I got. Regards, Aly Row Number user time qty location hour item area difference (in minutes) gap 49 A1PATEL 2018-05-31 07:30:22.000 2 L4C:M26A 07 50131644 L4 1 0 50 A1PATEL 2018-05-31 07:30:47.000 1 L4C:M54A 07 50131497 L4 0 0 51 A1PATEL 2018-05-31 07:31:13.000 1 L4C:N35A 07 701249 L4 1 0 52 A1PATEL 2018-05-31 07:36:22.000 1 L4A:A26A 07 50372859 L4 5 1 53 A1PATEL 2018-05-31 07:36:34.000 1 L4A:A33A 07 1403180 L4 0 0

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 columns and update their values as needed. I am expert in .Net 4.6, Asp.net, REST / SOAP web services, WCF, MVC 5, JavaScript, JQuery, Asp.net Web API, LINQ, Entity Framework, Amazon MWS, HTML, XML,CSS, PL/SQL. Actually, I am still building my profile here that's why I am offering a low cost, my only concern now is client satisfaction. I hope I can help you and it would be my pleasure to complete and deliver your task.

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 checked your requirements. We have right skills to work on this assignment. We are a team of professionals including experienced analysts, designers, project managers, developers and QA people having great expertise in web applications development mainly on core PHP, PHP with open sources (Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc. and mobile applications on ios and Android platform. Our award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. I am ready to discuss with you with best Regards

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