Informix Pass-Through Query

£10-20 GBP

Fullført

Lagt ut

nesten 6 år siden

£10-20 GBP

Betalt ved levering

Hello, I need some help with an informix pass through query. Im currently connected to the database using access. The query below needs modifiying SELECT idc_userid as User , event_ts as hours, after_event_qty as Qty, event_loc1_text as Location, event_ts as Time, item_nbr as Item, substr(event_loc1_text,1,2) as Area FROM wms_appl_event WHERE ((event_type_desc)="PICK_OP") and ((event_ts) > today) Event_ts as hours - Needs to display only the hour (currently [08/05/2018 08:11:48] needs to show [08] I need a column for the Min from event_ts for each idc_userid within the time range i need a column for the Max from event_ts for each idc_userid within the time range i need a column called rate for the sum for the user divided by 1200 Where and ((event_ts) > today) needs to be (between today+07:00 and today+15:00)

Prosjekt-ID: 16924112

Om prosjektet

5 forslag

Eksternt prosjekt

Aktiv 6 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@jlgonzadba

I can help you with datetimes and dates informix data types , and aggregates. I will give you the sentence/s that you need. The best solution depends on your infomix database server version.

£18 GBP om 1 dag

5,0

(2 omtaler)

0,8

5 frilansere byr i gjennomsnitt £23 GBP for denne jobben

@softcarve

Hi, I have good proficiency in sql and worked on informix. Available to start now. please get in touch to discuss more. Regards, Manish

£44 GBP om 2 dager

4,9

(95 omtaler)

5,8

@marcellp

I have demonstrated experience on this site working with databases and SQL development and I think I have a solution for you that you can deploy pretty quickly if you award me your project. Message me with any extra information if you would like to work with me.

£15 GBP om 1 dag

5,0

(8 omtaler)

3,8

@choudharywebinfo

I am mohan choudhary, 3+ years experienced in websites and e-commerce development using HTML, HTML5, cSS, PHP/MySQL, Cake Php, laravel,Codeigniter, Anguler JS, Android,wordpress, IOS. * I Have best experience in laravel Framework * Payment gateway integration like:- paypal,payUmoney, skrills etc * Responsive website - Cross browsers supportive * Any requested features will be completed. * 3 months Support * Cheapest Cost & Best Service * Quality assurance * Professional English Support 24*7 You'll be given 90 days free of cost post sell support. Can you please come over chat to discuss further regarding the project as I would love to hear more about the idea/concept? Thanking you! Regards, MOhan Thanks, Diamond looking forward for your reply.

£18 GBP om 1 dag