Query Syntax Flashcards

1
Q

HAVING

A

SELECT LastName, SUM(PointsScored) AS ps
FROM Roster
GROUP BY LastName
HAVING ps > 0;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly