Many people, young and old alike, both women and men, are now interested in learning Aikido, not only in the country where it originated – Japan, but also anywhere else in the world, including Australia. When talking about Aikido, it’s essential to also learn basic Aikido bokken techniques. You might get confused as to the […]
cannot use DISTINCT with WITHIN GROUP in Postgres
I am trying to make below query compatible with Postgres, which is originally written for Oracle select concat(s.udise_sch_code ,tch.teacher_id) comp_id, s.sch_id as sch_id, s.udise_sch_code as sch_code, s.school_name as school_name, v.latitude as latitude, v.longitude as longitude, tch.teacher_id as tch_id, tch.name as tch_name, tch.social_category as social_cat, to_char(tch.startdate,’yyyy-MM-dd-HH:mm’) as startdate, **LISTAGG(DISTINCT phone_no, ‘,’) WITHIN GROUP (ORDER BY phone_no) […]
What is Better – Slick Tiles or Synthetic Ice?
The world of at-home hockey training products is incredibly vast. You may have been a little surprised when you started going down this rabbit hole when you discovered just how many things that you have to choose from. One of the hardest choices to make is trying to determine which is better, slick tiles vs […]
Top 5 T20 Leagues Around The World
The game of cricket has evolved so much in the past few years after the introduction of T20 leagues. The playing style has totally changed. The orthodox shots have been changed to new experimental ones, Yorkers have taken place of length and swing deliveries. Not only the playing style but the perspective of fans towards […]