[net.database] SQL count function

roth@im4u.UUCP (Mark Roth) (10/18/85)

Does anyone know if  COUNT(*) is allowed in a group by query, like

SELECT p#,COUNT(*)
FROM   SP
GROUP BY p#

which gets the p# and count of all tuples in each group?

Mark Roth (roth@sally.UTEXAS.EDU)