Posts by user131478 • 1 point

• 0

  votes

  1

  answer

  71

  views

  A: SQL group records by time

  Failed to enter the "num_veh" column in your sub-select SELECT grupos, SUM(num_veh) as quantidade FROM ( SELECT num_veh, ( CASE WHEN DATE_FORMAT(time, '%H:%i:%s') > '00:00' &&…

  sql syntax

  answered 5 years, 10 months ago user131478 1