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 #373831]

Mon, 14 May 2001 20:49

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 #373833 is a reply to message #373831]

Mon, 14 May 2001 21:51

Sarada
Messages: 27
Registered: April 2001

Junior Member

Let's say your Insurance_policies table holds

POLICY_NO
POLICYHOLDER_NAME
AMOUNT_INSURED
...
Data
1 abc 100000
1 xyz 100000
2 def 50000
3 eee 150000

SELECT policy_no, COUNT(*)
FROM insurance_policies
GROUP BY policy_no
/

If this doesn't help you, post your table descriptions and we'll try to help u.

Orashark

Report message to a moderator