Re: Need Unique word search/count on DB. Any suggestions?

Hi Randy,

If I understand correctly the following will do the trick:

	SELECT DISTINCT <column_name>, COUNT(*)
	FROM <table_name>
	GROUP BY <column_name>;

Regards

Jerry

Randy Wyatt wrote:
>
> I have been requested to obtain a listing of unique words and their count in
> all rows of a specific column in our Oracle 7.1 database. Can anyone provide
> me with any clue as to how I can do this? Sql*Plus is the only tool I have.
> Thanks!
 

-- 
Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_p3.net 	Opinions are mine not those of ICT Group