select only those rows that have more than 2 entries based on key field
- From: "Jess" <jasicari@xxxxxxxxx>
- Date: 30 Aug 2006 07:48:05 -0700
Hi All,
I have a table that has 2 entries per employee with a few exceptions.
How do I select only those individuals that are the exception? that is,
either <2 or >2 entries?
thanks!
Jess
.
- Follow-Ups:
- Prev by Date: Re: Convert Number to Time format
- Next by Date: RE: date query
- Previous by thread: Convert Number to Time format
- Next by thread: Re: select only those rows that have more than 2 entries based on key field
- Index(es):