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
  • 704,970
  • 168
  • 1,303
  • 1,425
Jae
  • 61
  • 2
  • 9

0 Answers0