OraFAQ Forum: Server Administration » To retrieve the frequency of occrance from a column

Home » RDBMS Server » Server Administration » To retrieve the frequency of occrance from a column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To retrieve the frequency of occrance from a column [message #56972]

Fri, 09 May 2003 13:50

Bhaskar Challa
Messages: 2
Registered: May 2003

Junior Member

Hi all,

There is a column in my table say "winning_no", i would like to retrieve the frequency of occurance of each distanct number in that column and also the numbrer of times occured(for each number). the out put should go into a form.

expecting a positive reply at the earliest..

Thanks in advance

Bhaskar

Report message to a moderator

Re: To retrieve the frequency of occrance from a column [message #56973 is a reply to message #56972]

Fri, 09 May 2003 15:33

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select winning_no, count(*)
  from table_name
 group by winning_no;

Report message to a moderator

Re: To retrieve the frequency of occrance from a column [message #56974 is a reply to message #56973]

Fri, 09 May 2003 15:41

Bhaskar Challa
Messages: 2
Registered: May 2003

Junior Member

i want this data to dispaly in the form.. how to do that..

Report message to a moderator

Previous Topic:	9iAS
Next Topic:	Patch Update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:30:18 CDT 2024