sql query help
- From: "hharry" <paulquigley@xxxxxxx>
- Date: 26 Apr 2006 14:43:02 -0700
hello all,
i have this table:
CREATE TABLE [dbo].[Table1] (
[person_id] [int] NULL ,
[dob] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
with these values:
insert into Table1 values ('1', '15/12/1975')
insert into Table1 values ('1', '01/01/1980')
insert into Table1 values ('2', '15/12/1975')
insert into Table1 values ('1', '15/12/1975')
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
thanks in advance
.
- Follow-Ups:
- Re: sql query help
- From: Hugo Kornelis
- Re: sql query help
- Prev by Date: Re: Please help quick statement check
- Next by Date: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
- Previous by thread: SQL 2005 Encryption questions
- Next by thread: Re: sql query help
- Index(es):