GROUP BY

From: John Thomas <John_at_toronto.demon.co.uk>
Date: Tue, 22 Nov 1994 00:05:48 +0000
Message-ID: <785462747snz_at_toronto.demon.co.uk>

Select bldg, room, count(*)' items in this room' from table
group by bldg, room
...

-- 
John Thomas, Oracle Team Leader                E-Mail: John_at_toronto.demon.co.uk
The shorter the sig, the smarter the author.                 Tel: 0181 944 9858

Received on Tue Nov 22 1994 - 01:05:48 CET

This message: [ Message body ]
Next message: Mark J. Thompson: "Using Access with ORACLE?"
Previous message: Mark J. Thompson: "Converting Access DB to ORACLE?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message