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

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -

-
good morning i using angularjs-nvd3-directives, great, having difficulties when setting color of multi bar chart ( http://cmaurer.github.io/angularjs-nvd3-directives/multi.bar.chart.html ). the show legend works well: <div ng-controller="examplectrl"> <nvd3-multi-bar-chart data="exampledata" id="showlegendexample" width="550" height="300" showxaxis="true" showyaxis="true" xaxistickformat="xaxistickformatfunction()" showlegend="true"> <svg></svg> </nvd3-multi-bar-chart> </div> but when add option in conjunction color="colorfunction()" where, var colorarray = ['#ff0000', '#0000ff', '#ffff00', '#00ffff']; $scope.colorfunction = function() { return function(d, i) { return colorarray[i]; }; } the color of cha
Read more