Posts by Déborah Azevedo • 15 points

• 1

  votes

  1

  answer

  31

  views

  Q: Convert percentage

  I’m having trouble converting % my code: select veiculos , qtd , trunc(qtd / sum(qtd) over()* 100, 4 ) PERC from ( select ent_datahora_entrada , veiculos , count(*) qtd from ( select…

  sql database group-by where count

  asked 3 years, 10 months ago Déborah Azevedo 15

• 0

  votes

  1

  answer

  39

  views

  Q: group each period per month

  I’m doing this consultation, but I’m not able to group each period per month, the previous year. For each month of the year preceding the current year, return the amount of parked cars per period…

  sql query datetime group-by case

  asked 3 years, 10 months ago Déborah Azevedo 15