0

Sample table:

date    |  name  | record  
7/27/16 | john   | H  
7/27/16 | john   | P  
7/28/16 | john   | P  
7/28/16 | john   | L  

Results:

date    |  name  | record  
7/27/16 | john   | H,P  
7/27/16 | john   | H,L  

Query:

SELECT 
    date, name, record 
FROM
    TABLE 
GROUP BY 
    date, name, record(not sure how to do this part)
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Jae
  • 61
  • 2
  • 9

0 Answers0