Posts by Tássio Ribeiro • 31 points

• 3

  votes

  1

  answer

  47

  views

  Q: Show value 0 when no data is available

  To show in an sql query, value 0 when there is no data in the table? SELECT ae.dt_data, to_char(ae.dt_data, 'dy'), case when to_char(ae.dt_data, 'dy') = 'sun' then 'Domingo' when to_char(ae.dt_data,…

  sql postgresql

  asked 3 years, 10 months ago Tássio Ribeiro 31