SQL Tricks Contents Purpose Nota bene Example schema Selecting records How do I get a list of items and the sum of another column in a table? How do I concatenate a list of string values each relavant to a row? How do I get a list of items and filter the result set on some aggregate?