SQL count function

Article View: net.database

Article #42

#42

From: Mark Roth
Date: Fri, 18 Oct 1985 16:46

9 lines
734 bytes

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)

Technical Details

Message-ID: <590@im4u.UUCP>

Path: arc1-ca.pugleaf.net!utzoo!linus!decvax!ucbvax!ucdavis!lll-crg!mordor!ut-sally!im4u!roth

Show Full Headers

Complete Article Headers

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: arc1-ca.pugleaf.net!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