SQL count function

Thread View: net.database

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Mark Roth Fri, 18 Oct 1985 16:46

#42

Author: 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)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads