Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Specialised Counts
do you mean :
select input, count(*) from table group by input;
Assuming you are asking about a column in a table :o)
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: markstarmer_at_hotmail.com (Mark Starmer)
[mailto:markstarmer_at_hotmail.com]
Posted At: Friday, April 04, 2003 11:02 AM
Posted To: server
Conversation: Specialised Counts
Subject: Specialised Counts
Is there a way (perhaps using nested SQL) to count the number of occurances of each distinct record ie
Input
Output
Thanks a lot
M Starmer Received on Fri Apr 04 2003 - 04:48:30 CST