|
|
Posted by Hugo Kornelis on 04/27/06 00:50
On 26 Apr 2006 14:43:02 -0700, hharry wrote:
(snip)
>i am trying to construct a query which will return those person's with
>more than 1 date of birth
>e.g.
>person 1 has 2 dates of birth - 01/01/1980 and 15/12/1975
Hi hharry,
SELECT person_id, COUNT(*)
FROM Table1
GROUP BY person_id
HAVING COUNT(*) > 1
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|