Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Posting-Version: version B 2.10.2 9/18/84; site im4u.UUCP
Path: utzoo!linus!decvax!ucbvax!ucdavis!lll-crg!mordor!ut-sally!im4u!roth
From: roth@im4u.UUCP (Mark Roth)
Newsgroups: net.database
Subject: SQL count function
Message-ID: <590@im4u.UUCP>
Date: Fri, 18-Oct-85 12:46:17 EDT
Article-I.D.: im4u.590
Posted: Fri Oct 18 12:46:17 1985
Date-Received: Mon, 21-Oct-85 06:36:46 EDT
Distribution: net
Organization: U. Texas CS Dept., Austin, Texas
Lines: 9

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)