sql - db2 specific query for count of distinct rows -

-

i using db2. have query: 

select distinct  order_number, trdm trademark, cmdnsm customer_name db1.ordfa join db2.ccadf on sford# = wdrso join db2.dada06 on wd3adf = wd3fla join db1.cmp1 on c1lk2 = sf2lk year = '14' , part = '5484' order customer_name, trademark

and result set above query

order_number    trademark      customer_name   2220824.        air          epr products inc   2254614.       avalon        epr products inc   2214146.       avalon        epr products inc   2338002.       avalon        epr products inc   2102733.       boss          epr products inc   2286148.        cdc          epr products inc   2116148.        cdc          epr products inc   2032105.        hc           summlc   2014046.        hc           summlc   2232312.       sdexo         summlc   2267369.       sdexo         summlc   2085280.       sdexo         summlc   2170433.       sdexo         summlc   2179283.       sdexo         summlc   2378745.       sdexo         summlc

what need db2 query give me result set: 

 num_orders      trademark      customer_name      6            sdexo          summlc      3            avalon         epr products inc      2            cdc            epr products inc      2            hc             summlc      1            boss           epr products inc      1            air            epr products inc

if db2 supports ansi standard sql believe need add acountandgroup by:

select      count(distinct order_number) num_orders,     trdm trademark,     cmdnsm customer_name db1.ordfa join db2.ccadf on sford# = wdrso join db2.dada06 on wd3adf = wd3fla join db1.cmp1 on c1lk2 = sf2lk year = '14' , part = '5484' group trdm, cmdnsm order num_orders desc, customer_name, trademark

Comments

Post a Comment

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

-
i need in configuring java on machine because, when try loading forms, loader goes in circles , gives error: java.lang.classnotfoundexception: oracle.apps.fnd.formsclient.formslauncher.class @ sun.plugin2.applet.applet2classloader.findclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass0(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass(unknown source) @ java.lang.classloader.loadclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadcode(unknown source) @ sun.plugin2.applet.plugin2manager.createapplet(unknown source) @ sun.plugin2.applet.plugin2manager$appletexecutionrunnable.run (unknown source) @ java.lang.thread.run(unknown source) i have tried re-installing firefox, older versions of java runtime environments, disabling proxy. what missing? application working on other machines. i spent around 100 hours finding s...
Read more

c# - how to use buttonedit in devexpress gridcontrol -

-
Image
i trying create gridcontrol buttonedit in 1 of columns. when user clicks button edit, popups form select product. when selection done on popup, returns datarow selection main grid below. but when column loses focus, value wrote column disappear. here code creates gridcontrol's data , buttonedit's click event. private void frmsiparisnew_load(object sender, eventargs e) { dt = new datatable(); dt.columns.add("malzeme_kodu",typeof(string)); dt.columns.add("malzeme_aciklama", typeof(string)); dt.columns.add("adet", typeof(decimal)); dt.columns.add("birim", typeof(string)); dt.columns.add("fiyat", typeof(decimal)); dt.columns.add("kur", typeof(string)); dt.columns.add("tutar", typeof(decimal)); datarow dr = dt.newrow(); dt.rows.add(dr); gc.datasource = dt; } private void repositoryitembuttoneditmal...
Read more

How do you convert a timestamp into a datetime in python with the correct timezone? -

-
you naively expect work: import pytz datetime import datetime def tz_datetime_from_timestamp(timestamp): """convert timestamp datetime """ tz = pytz.timezone('australia/perth') server_time = datetime.utcnow() delta = tz.utcoffset(server_time) value = datetime.utcfromtimestamp(timestamp).replace(tzinfo=tz) return value + delta print tz_datetime_from_timestamp(1416387060) and convert timestamp 1416387060 wed nov 19 16:51:00 2014 gmt+8:00. ...but not. prints: 2014-11-19 16:51:00+07:43 the timezone of australia/perth not gmt+7:43. it gmt+8:00. unequivocally stated on australian government website http://www.australia.gov.au/about-australia/our-country/time : awst equal coordinated universal time plus 8 hours (utc +8). so, heck pytz pulling 7.43 from? well, turns out pytz pulls data http://www.iana.org/time-zones time zone database, , database states: # western australia # # rule name type in on @...
Read more