Tamamlanmış

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

Beceriler: Veri Tabanı Yönetimi, Microsoft SQL Server, MySQL, Oracle, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 4 değerlendirme ) Le193ej, United Kingdom

Proje NO: #17080081

Seçilen:

kurbsky

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(3 Değerlendirme)
1.5

Bu iş için 14 freelancer ortalamada £19 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(28 Değerlendirme)
5.2
softcarve

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(66 Değerlendirme)
5.5
amitbanerjee2812

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(8 Değerlendirme)
4.8
ashupathania

I will complete youe requirement on time.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(29 Değerlendirme)
5.1
Agiletechstudio

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 ?

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(13 Değerlendirme)
4.2
alyelhaddad

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

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
3.0
sreenivas2903

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

in %bids___i_period_sub_35% gün içinde21%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.8
engdinamallam

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(1 Yorum)
2.3
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
technosoft1vw

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
snehaaddala

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0