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 6 years ago user131478 1