How to get count of distinct column in ORACLE

select  DISTINCT COL_NAME_1,count(DISTINCT COL_NAME_2) as COUNT from TABLE_NAME  group by COL_NAME_1;

Comments

  1. onlinechemicalstoreJanuary 13, 2020 at 2:59 AM

    hi
    There,
    Thank you for sharing a knowledgeable blog with us I hope that you will post many more blog with us:

    Our Pharmacy offers a wide range of medications, pain killers, pills and research chemicals at affordable prices.The applied mathematics of a pragmatical capture cautionary system. Stacey wc, litt b can you buy real oxycodone online.

    Click here for Can I Buy Oxycodone Online

    ReplyDelete
  2. newagevendor.comApril 21, 2020 at 12:31 PM

    Welcome to newagevendor  newagevendor.com . This is the best place to shop for your Pan meds and other stuffs.
    Our products include; ritalin
    BUY RITALIN  ONLINE

    website: https://newagevendor.com/
    Email : info@newagevendor.com
    Wickr ID: magic420stuffs
    WhatsApp: +18652640972


    buy cocaine online buy Ritalin online buy crystal meth onlinebuy Dilaudid online buy methadone online buy ketamine onlinebuy oxycodone onlinebuy painkillers online buy Xanax online buy Adderall online buy Norco online buy Roxicodone online buy crack cocaine online buy jwh-018 online buy apvp online buy mdpv online buy pure cocaine online  order cocaine online  
      buy pain meds online  buy painkillers online


    ReplyDelete
  3. Jon HendoFebruary 25, 2021 at 6:55 AM

    Good. I am really impressed with your writing talents and also with the layout on your weblog. Appreciate, Is this a paid subject matter or did you customize it yourself? Either way keep up the nice quality writing, it is rare to peer a nice weblog like this one nowadays. Thank you, check also virtual edge and thanks for organizing the event

    ReplyDelete
  4. RianFebruary 25, 2021 at 2:54 PM

    Ada banyak visi tentang bagaimana mencapai pertanian berkelanjutan yang menyediakan makanan dan jasa ekosistem yang cukup untuk generasi sekarang dan masa depan di era perubahan iklim, peningkatan biaya energi, keresahan sosial, ketidakstabilan keuangan dan peningkatan degradasi lingkungan. Sistem pertanian baru yang mampu menghadapi tantangan dunia yang berubah dengan cepat membutuhkan minimal sepuluh atribut yang merupakan elemen penentu dari Pertanian Hijau. Tantangan utama adalah untuk mengidentifikasi serangkaian ambang yang harus dipenuhi oleh setiap strategi produksi pertanian, di luar itu tren yang tidak berkelanjutan yang disebabkan oleh teknologi pertanian akan mengarah pada fenomena titik kritis. Hanya gaya pertanian yang memenuhi kriteria ambang batas yang ditetapkan sambil memajukan masyarakat pedesaan menuju pangan, energi, dan kedaulatan teknologi yang akan dianggap sebagai bentuk Pertanian Hijau yang layak. Mempertimbangkan keragaman konteks ekologi, sosio-ekonomi, sejarah dan politik di mana sistem pertanian telah berkembang dan berkembang, adalah bijaksana untuk menetapkan seperangkat prinsip yang fleksibel dan dapat diadaptasi secara lokal dan batas-batas keberlanjutan dan ketahanan untuk agroekosistem masa depan segera. cek juga yukusaha dan Budidaya Pisang

    ReplyDelete

Post a Comment

Popular posts from this blog

Spring MVC- Redirect from one controller to another

In spring mvc its very easy to redirect from one controller to another controller Example : @Controller @RequestMapping("/springcontroller1") public class SpringController1{ } @Controller public class SpringController2{ //thinking of redirecting on clicking on a method @RequestMapping(value = "/SpringController2cancel.abc", method = RequestMethod.POST, params = "action=cancel")     public ModelAndView cancel(@ModelAttribute("MyForm") MyForm myForm, BindingResult errors,SessionStatus sessionStatus,HttpServletRequest request) throws MyException {         ModelAndView modelAndView = new ModelAndView();                 sessionStatus.setComplete();         //redirecting to controller1         return new ModelAndView("redirect:/springcontroller1.abc");     } }
Read more

Integrating Struts2 with Spring Security using Custom Login Form

Integrating Struts2 with Spring Security involves few configurations. Add all the spring core and spring security related jars-- spring -3.0.6 Struts2-Action :gets user principal and displays it on jsp after authentication package com.prdc.spring3; import java.util.ArrayList; import javax.servlet.http.HttpServletRequest; import java.util.Iterator; import java.util.List; import java.util.Properties; import java.util.Set; import org.apache.struts2.ServletActionContext; public class HelloWorld { private String message; private String username; public String getMessage() { return message; } public void setMessage(String message) { this.message = message; } public String execute() { /*to get the authenticated username*/ HttpServletRequest request = ServletActionContext.getRequest(); this.setUsername(request.getUserPrincipal().getName()); ...
Read more