Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Specialised Counts

Specialised Counts

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 4 Apr 2003 11:48:30 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7038380D3@lnewton.leeds.lfs.co.uk>


do you mean :

	select input, count(*) 
	from table
	group by input;

Assuming you are asking about a column in a table :o)

Cheers,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
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



John
John
John
Jim

Output



John - 3
Jim -1

Thanks a lot

M Starmer Received on Fri Apr 04 2003 - 04:48:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US