OraFAQ Forum: Server Administration » How to use count function to count insurance policy which more than one person hold?

Home » RDBMS Server » Server Administration » How to use count function to count insurance policy which more than one person hold?

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

How to use count function to count insurance policy which more than one person hold? [message #373828]

Mon, 14 May 2001 20:30

Steve
Messages: 190
Registered: September 1999

Senior Member

Hi,All:
How can I use count function to count insurance policy
which more than one person hold? (It means if more than
one person hold this policy, then I only need count this policy once)
Thanks
Steve

Report message to a moderator

Re: How to use count function to count insurance policy which more than one person hold? [message #373832 is a reply to message #373828]

Mon, 14 May 2001 21:03

R Venkataraman
Messages: 2
Registered: May 2001

Junior Member

select insurance_no,count(*) from insurance_details group by insurance_no having count(*) > 1;

Report message to a moderator

Previous Topic:	How to use count function to count insurance policy which more than one person hold?
Next Topic:	alter column width

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:15:29 CST 2024